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

Retaining Stored Procedure Permissions

P: n/a
Is there any way to retain the permissions previously granted on a
stored procedure through an explicit "GRANT EXECUTE" statement, after
recompiling said procedure? We are using group permissions for SP
execution. Every time a developer rebuilds a procedure, it appears
that it is internally dropped and recreated. It must during the "drop"
phase that all previous permissions are getting lost. I've searched
for options in the development center and general tools settings, but
haven't found anything.

Currently what happens is that someone will open a procedure in
development center and by default, the "build" option is checked, when
the procedure is imported. Even if no changes are made, the procedure
will lose permissions. Application then gets the SQL0551 error until I
re-grant permissions to group.

Environment is 8.2 FP 9, AIX 5.3. Any help greatly appreciated!


Mar 13 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.