Page 1 of 1
How to grant drop table privelege to user
Posted: Wed Feb 04, 2004 12:09 am
by rbahadur
Hi please can any one help me in granting the drop table privilege on a UV table to a specific user.
Posted: Wed Feb 04, 2004 12:42 am
by ray.wurlod
There is no specific DROP table privilege.
A UV table may be dropped by its creator, or a user with DBA privilege.
To determine who has DBA privilege execute the following command, either through your Administrator client command window, or in a telnet session connected to DataStage environment. (Results from the site where I am working today are also shown. Note that identifiers in the command - table name and column names - are case sensitive.)
Code: Select all
SELECT NAME, DBAUTH, RESOURCEAUTH
FROM UV_USERS
WHERE DBAUTH = 'YES';
User Name......... DBauth Privilege Resource Privilege
dsadm YES YES
root YES YES
2 records listed.
Posted: Wed Feb 04, 2004 12:50 am
by rbahadur
Thank you for your reply.