Granting "DROP TABLE" privs to a user 1

[SantaMufasa]

I'm sure my questions are elementary for you DB2 pros, but I (as an Oracle DBA) had responsibility for a DB2 database installation dumped into my lap recently and I want to ensure that I am using the correct commands the first time since the target db is a production environment.

I have a non-DBA user "A" that must issue "DROP TABLE <tablename>" on database "B", schema "C". Could someone please confirm for me:

1) What permission(s) must user "A" have to accomplish such a DROP, and
2) Once user "A" has the correct privileges, what is the correct qualification syntax in the "DROP TABLE..." command?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[gregsimpson]

Mufasa

db2 grant dropin on schema db1schema to mufasa

db2 drop table db1schema.tablename

You could also consider giving them dbadm.

Cheers
Greg

 

[SantaMufasa]

Greg,

You suggestion #1 beautifully did the trick. Please accept a Purple Star for your valuable post.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[gregsimpson]

Mufasa,

thanks much appreciated. It was the least I could do, considering the amount of effort you put into my little jaunt into the Oracle World.

http://www.tek-tips.com/viewthread.cfm?qid=1180477&page=1

Cheers
Greg

 

[SantaMufasa]

Well, Greg, I guess this is "proof" that "What goes around, comes around."

Thanks again !

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.