By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Privileges on SP??

P: n/a
Hi All
db2 8.1.3 Windows
I have a user projuser in Windows.Using this user I have created a SQL
Stored Procedure user_proc1.Implicitly projuser has CONTROL privilege and
many others on this SP and its packages.If I do not want this user to be
able to drop this SP what all privileges/Authorities I need to revoke?I
tried by revoking DROPIN privilege of this user on its schema but to no
avail.Also db2 is not allowing to remove CONTROL privilege on its
package.

TIA
Regards
Praveen
Apr 11 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.