Our developers are developing stored procedures (SP), they need to constantly modify SQL code in SP. There is no merit for DBA to control the refreshing (drop/create) of SPs from what I see.
This is what I've granted them: (1) BINDADD (2) EXECUTE on procedure schema-name.* (3) SELECT on tables (SP involves SELECT only)
Is it possible to grant developers privileges to drop stored procedure without allowing them to drop other schema objects such as table? I tried DROPIN but this allows them to drop table as well.
The error I got when I logged on as developer (Without being granted DROPIN):
D:\db2 drop specific procedure PROC01
SQL0551N "DB2DEV' does not have the privilege to perform "DROP PROGRAM" on object "DB2ADMIN.P1470254". SQLSTATE=42501
Where PROC01 is procedure name and DB2ADMIN.P1470254 is the corresponding program name.
The platform is W2k DB2 V8 FP2.
Thank you for your help.
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to http://ninemsn.com.au/mobilemania/default.asp
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
