How to grant drop table privelege to user
Moderators: chulett, rschirm, roy
How to grant drop table privelege to user
Hi please can any one help me in granting the drop table privilege on a UV table to a specific user.
Ravinder Bahadur
OCP DBA
DB2 Certified User
DB2 DBA
OCP DBA
DB2 Certified User
DB2 DBA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.