Authorization/Privilege Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen_db2 - 24 Mar 2006 14:03 GMT

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

Reply to this Message

Serge Rielau - 24 Mar 2006 14:55 GMT

> 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/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Knut Stolze - 24 Mar 2006 15:01 GMT

>> Hi All
>> I need to give authrization/Privilege for a user such that he should be
[quoted text clipped - 3 lines]
>> the authorization/Privilege required for Compiling a Stored Procedure.
> You have to grant bind privilege on the underlying package:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/r0000962.htm

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

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message