Grant create user/create database problem

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Grant create user/create database problem

Rate Topic

Display Mode

Topic Options

Author

Message

pahmed

Posted 11/7/2009 11:07:50 PM

Forum Newbie

Group: Forum Members
Last Login: 11/15/2009 7:02:46 AM
Posts: 6, Visits: 13

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?

Post #17282

pahmed

Posted 11/11/2009 11:19:55 AM

Forum Newbie

Group: Forum Members
Last Login: 11/15/2009 7:02:46 AM
Posts: 6, Visits: 13

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.

Post #17310

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 3 ( 3 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 9:02am