Solved

Revoking drop table

Posted on 2004-04-20
3
621 Views
Last Modified: 2008-03-04
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.
0
Comment
Question by:k_murli_krishna
  • 2
3 Comments
 
LVL 13

Expert Comment

by:ghp7000
Comment Utility
db2 revoke dropin on schema <schema name> from user xxxx; OR
db2 revoke dropin on schema <schema name> from group xxxx;
you do not need to change any OS settings
0
 
LVL 17

Author Comment

by:k_murli_krishna
Comment Utility
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.
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 100 total points
Comment Utility
this is the standard, the user who created the table has control over the table. If you try and revoke the control privlidge from the user who 'owns' the table, you will get SQL0555N, An authorization ID cannot revoke a privilege from itself.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now