470,594 Members | 1,401 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

GRANT DROP on TABLE

Hi guys,

table "A" was created by user "USER1". Is there a way for USER1 to
grant access to DROP that table to user "B"?

The answer I heard so far was "only if user B has administrative
priviligies". Any evidence to the contrary?

Thanks
Bogdan

Dec 28 '05 #1
3 10664
I f you want to do this, the command is
db2 grant control on table <tbname> to USER1

Control privilege also gives implicitly ALL to USER1 but it is the only
privilege that allows the drop option, apart from the owner, definer of the
table.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"kangaroo" <sh*******@yahoo.com> a écrit dans le message de news:
11**********************@g44g2000cwa.googlegroups. com...
Hi guys,

table "A" was created by user "USER1". Is there a way for USER1 to
grant access to DROP that table to user "B"?

The answer I heard so far was "only if user B has administrative
priviligies". Any evidence to the contrary?

Thanks
Bogdan


Dec 28 '05 #2
Hi
There is no need for 'B' to have administrative authority to drop the
'A' table, provided 'B' has been given the privilage CONTROL on that
table..But keep in mind that USER1 (owner of the table) can't give
CONTROL privilage over the table which he owns. Only administrators
either SYSADMIN or DBADMIN only can give CONTROL privilages to any
other user ids.
CONTROL privilage gives SELECT,UPDATE,DELETE,INSERT,ALTER ...but not
DROP.

I hope i have anwered to ur question...
Bye

Dec 29 '05 #3
Pierre, Raja, thank you both, that's exactly what I was looking for.

Bogdan

Dec 29 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by | last post: by
reply views Thread by Charles Cantrell | last post: by
2 posts views Thread by Eric | last post: by
4 posts views Thread by TycoonUK | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.