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

Authorization/Privilege Issue

P: n/a
Hi All
I need to give authrization/Privilege for a user such that he should be
able to run stored procedures but cannot change its code i.e he should not
be able to compile it.I looked in the documentation but for ROUTINES there
is only 'EXECUTE' privilege which is for running the SP's.What is the
authorization/Privilege required for Compiling a Stored Procedure.

TIA
Praveen

Mar 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Praveen_db2 wrote:
Hi All
I need to give authrization/Privilege for a user such that he should be
able to run stored procedures but cannot change its code i.e he should not
be able to compile it.I looked in the documentation but for ROUTINES there
is only 'EXECUTE' privilege which is for running the SP's.What is the
authorization/Privilege required for Compiling a Stored Procedure.

You have to grant bind privilege on the underlying package:
http://publib.boulder.ibm.com/infoce...n/r0000962.htm

But I wonder whether a call to
REBIND_ROUTINE_PACKAGE()
Already encapsulates this privilege.
Try that one first. If it doesn't work then you have to hunt for the
package name. Should be logged in either SYSCAT.PACKAGEDEP or
SYSCAT.ROUTINEDEP

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 24 '06 #2

P: n/a
Serge Rielau wrote:
Praveen_db2 wrote:
Hi All
I need to give authrization/Privilege for a user such that he should be
able to run stored procedures but cannot change its code i.e he should
not be able to compile it.I looked in the documentation but for ROUTINES
there is only 'EXECUTE' privilege which is for running the SP's.What is
the authorization/Privilege required for Compiling a Stored Procedure.

You have to grant bind privilege on the underlying package:

http://publib.boulder.ibm.com/infoce...n/r0000962.htm

Do you need the BIND privilege also for SQL/PL procedures?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.