All Forums Enterprise
yolande 6 posts Joined 11/09
07 Nov 2009
Grant create user/create database problem

I have installed teradata demo version 12.o. Using dbc I created a user for the administration purpoises as DBAdmin. I want to grant previleges to the new user as grant create user to DBAdmin. I am getting the syntax error. Can some please let me know what is the excact syntax is. Does the demo version allows to grant create user or create database previleges to the other users?

yolande 6 posts Joined 11/09
11 Nov 2009

I was able to get the answer.
The steps are as follows:
Within DBC
Create user user1.
grant all on user1 to user1.
This allowed user1 to create database and other users.

You must sign in to leave a comment.