DBA query

Database
N/A

DBA query

What query should be written to grant a user to create database anywhere in the box?

3 REPLIES

Re: DBA query

grant create database,drop database on sysdba to username;
N/A

Re: DBA query

There is no global right to create databases in Teradata.

Create the neccessary SQL:
SELECT 'grant database on ' || databasename || ' to userxxx;'
FROM dbc.databasesV;

and then run the ourtput.

Dieter
N/A

Re: DBA query

Thanks for replying.

@vuduthala -
grant create database,drop database on sysdba to username;

Your query will grant user to create database just below sysdba.But not on a sysdba child.

For eg :

sysdba
|
- >database1

With your grant I can create another database below sysdba but cannot create database under database1.

Do try and give it a shot .

@Dieter - Thanks for SQL. Your query will grant create database privilege on the existing databases in a system.
How to make sure that a user can create a new database?