 | |
public priviledge on create procedure
comp.databases.ibm-db2 comp.databases.ibm-db2
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
public priviledge on create procedure -
08-29-2011
, 02:10 PM
#2
| |||
| |||
|
|
db2 udb 9.7.4 on AIX, I have revoked dbadm/CREATE_NOT_FENCED/IMPLICIT_SCHEMA from pubilc and user, but still they can create procedures. db2 => *CONNECT * *Database Connection Information *Database server * * * *= DB2/AIX64 9.7.4 *SQL authorization ID * = PREAD *Local database alias * = PDB db2 => *select * *from SYSCAT.dbauth where GRANTEE in ('PREAD' , 'PUBLIC') GRANTOR GRANTORTYPE GRANTEE GRANTEETYPE BINDADDAUTH CONNECTAUTH CREATETABAUTH DBADMAUTH EXTERNALROUTINEAUTH IMPLSCHEMAAUTH LOADAUTH NOFENCEAUTH QUIESCECONNECTAUTH LIBRARYADMAUTH SECURITYADMAUTH SQLADMAUTH WLMADMAUTH EXPLAINAUTH DATAACCESSAUTH ACCESSCTRLAUTH --------------------------------------------------------------------------- ----------------------------------------------------- ----------- --------------------------------------------------------------------------- ----------------------------------------------------- ----------- ----------- ----------- ------------- --------- ------------------- -------------- -------- ----------- ------------------ -------------- --------------- ---------- ---------- ----------- -------------- -------------- SYSIBM S PUBLIC G * * * * * N * * * * * Y * * * * * N * * * * * * N N * * * * * * * * * N * * * * * * *N * * * *N N * * * * * * * * *N * * * * * * *N * * * * * * * N N * * * * *N * * * * * N * * * * * * *N DB2PMTP U PMTPREAD U * * * * * N * * * * * Y * * * * * N * * * * * * N N * * * * * * * * * N * * * * * * *N * * * *N N * * * * * * * * *N * * * * * * *N * * * * * * * N N * * * * *N * * * * * N * * * * * * *N * 2 record(s) selected. db2 => * CREATE PROCEDURE TEST (in medianSalary DOUBLE) * * *LANGUAGE SQL * *BEGIN * *END DB20000I *The SQL command completed successfully. db2 => * DROP PROCEDURE TEST DB20000I *The SQL command completed successfully. |
you don't have to have CREATE_NOT_FENCED for SQL routines:
http://publib.boulder.ibm.com/infoce.../r0008329.html
You have to have this authority for EXTERNAL not fenced routines:
http://publib.boulder.ibm.com/infoce.../r0008328.html
Sincerely,
Mark B.
#3
| |||
| |||
|
|
On Aug 29, 11:10*pm, Anwei Shen <shenan... (AT) gmail (DOT) com> wrote: db2 udb 9.7.4 on AIX, I have revoked dbadm/CREATE_NOT_FENCED/IMPLICIT_SCHEMA from pubilc and user, but still they can create procedures. db2 => *CONNECT * *Database Connection Information *Database server * * * *= DB2/AIX64 9.7.4 *SQL authorization ID * = PREAD *Local database alias * = PDB db2 => *select * *from SYSCAT.dbauth where GRANTEE in ('PREAD' , 'PUBLIC') GRANTOR GRANTORTYPE GRANTEE GRANTEETYPE BINDADDAUTH CONNECTAUTH CREATETABAUTH DBADMAUTH EXTERNALROUTINEAUTH IMPLSCHEMAAUTH LOADAUTH NOFENCEAUTH QUIESCECONNECTAUTH LIBRARYADMAUTH SECURITYADMAUTH SQLADMAUTH WLMADMAUTH EXPLAINAUTH DATAACCESSAUTH ACCESSCTRLAUTH --------------------------------------------------------------------------- ----------------------------------------------------- ----------- --------------------------------------------------------------------------- ----------------------------------------------------- ----------- ----------- ----------- ------------- --------- ------------------- -------------- -------- ----------- ------------------ -------------- --------------- ---------- ---------- ----------- -------------- -------------- SYSIBM S PUBLIC G * * * * * N * * * * * Y * * * * * N ** * * * * N N * * * * * * * * * N * * * * * * *N * * * *N N * * * * * * * * *N * * * * * * *N ** * * * * * N N * * * * *N * * * * * N * * * * * * *N DB2PMTP U PMTPREAD U * * * * * N * * * * * Y * * * * * N ** * * * * N N * * * * * * * * * N * * * * * * *N * * * *N N * * * * * * * * *N * * * * * * *N ** * * * * * N N * * * * *N * * * * * N * * * * * * *N * 2 record(s) selected. db2 => * CREATE PROCEDURE TEST (in medianSalary DOUBLE) * * *LANGUAGE SQL * *BEGIN * *END DB20000I *The SQL command completed successfully. db2 => * DROP PROCEDURE TEST DB20000I *The SQL command completed successfully. Hi Anwei, you don't have to have CREATE_NOT_FENCED for SQL routines:http://publib.boulder.ibm.com/infoce...pic/com.ibm.db... You have to have this authority for EXTERNAL not fenced routines:http://publib.boulder.ibm.com/infoce...pic/com.ibm.db... Sincerely, Mark B.- Hide quoted text - - Show quoted text - |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.