467,189 Members | 1,298 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Privileges on SP??

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
  • viewed: 1006
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Marc | last post: by
4 posts views Thread by Amardeep Verma | last post: by
2 posts views Thread by Denis Martineau | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Marc | last post: by
8 posts views Thread by binary-nomad@hotmail.com | last post: by
2 posts views Thread by virgilio | last post: by
4 posts views Thread by Feldman Alex | last post: by
5 posts views Thread by Rahul B | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.