|
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
| |
Share this question for a faster answer!
