SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:30 AM
| ||||
| ||||
 Authorization/Privilege Issue 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      |
|
02-27-2008, 06:30 AM
| |||
| |||
| Re: Authorization/Privilege Issue 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 |
|
02-27-2008, 06:30 AM
| ||||
| ||||
| Re: Authorization/Privilege Issue 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 |
Linear Mode
