SEO

#1 (**permalink**) 02-27-2008, 05:41 AM

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

#2 (**permalink**) 02-27-2008, 05:41 AM

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" <sheptunov@yahoo.com> a écrit dans le message de news:
1135800118.739030.137680@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
>

#3 (**permalink**) 02-27-2008, 05:41 AM

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

#4 (**permalink**) 02-27-2008, 05:42 AM

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

Bogdan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

GRANT DROP on TABLE