07-27-07, 15:07 #1Registered User
- Join Date
- Aug 2004
Unanswered: Granting "With Grant Option" on Procedures and Functions
I am trying to execute the following command:
GRANT EXECUTE ON PROCEDURE NROSWI.* TO USER NRSAPPC WITH GRANT OPTION
The command line comes back as "DB20000I The SQL command completed successfully." I then issue a "commit", but when I check the user NRSAPPC permission's it doesn't show them as having "Grant Execute" authority on the stored procedures.
The documentation states "PROCEDURE schema.*
Identifies all the procedures in the schema, including any procedures that may be created in the future. In dynamic SQL statements, if a schema is not specified, the schema in the CURRENT SCHEMA special register will be used. In static SQL statements, if a schema is not specified, the schema in the QUALIFIER precompile/bind option will be used."
If anyone can advise me, it would be greatly appreciated.
07-27-07, 15:52 #2Registered User
- Join Date
- Jan 2007
- Jena, Germany
I just tried it and I cannot reproduce what you are saying:
GRANT EXECUTE ON PROCEDURE stolze.* TO USER abc@ SELECT grantor, grantee, schema, executeauth FROM syscat.routineauth WHERE grantee = 'ABC'@ GRANTOR GRANTEE SCHEMA EXECUTEAUTH -------- -------- ------- ------------ STOLZE ABC STOLZE GKnut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development