GRANT DROP on TABLE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kangaroo - 28 Dec 2005 20:01 GMT

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

Reply to this Message

Pierre Saint-Jacques - 28 Dec 2005 21:43 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Hi guys,
>
[quoted text clipped - 6 lines]
> Thanks
> Bogdan

Reply to this Message

Raja Shekar - 29 Dec 2005 05:35 GMT

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

Reply to this Message

kangaroo - 29 Dec 2005 18:52 GMT

Pierre, Raja, thank you both, that's exactly what I was looking for.

Bogdan

Reply to this Message