k_murli_krishna
asked on
Revoking drop table
1) We have db2 7.2 on AIX 5.1 and windows NT 4/2000.
2) We have many tables created in a schema logged in as a particular user.
3) What is the process to enable revoke of drop table for these already created tables.
4) Do we have to do any OS level settings.
2) We have many tables created in a schema logged in as a particular user.
3) What is the process to enable revoke of drop table for these already created tables.
4) Do we have to do any OS level settings.
ASKER
When I grant create table and createin I am able to create a table. Then although dropin is revoked I am able to drop the table if I am connected with same user with which I created the table.
How can I prevent dropping of tables connected as a user with whom I created the tables originally. Is this a bug in DB2 or a RDBMS standard.
How can I prevent dropping of tables connected as a user with whom I created the tables originally. Is this a bug in DB2 or a RDBMS standard.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
db2 revoke dropin on schema <schema name> from group xxxx;
you do not need to change any OS settings