How to grant drop table privelege to user

[rbahadur]

Hi please can any one help me in granting the drop table privilege on a UV table to a specific user.

[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.

[rbahadur]

Thank you for your reply.