Granting "With Grant Option" on Procedures and Functions

RonD · #1 (**permalink**) 07-27-07, 14:07

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.

Thanks
Ron

stolze · #2 (**permalink**) 07-27-07, 14:52

I just tried it and I cannot reproduce what you are saying:

Code:

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  G

So you should probably tell us a bit more what exactly you tried and how you came to your conclusions.

Internet Services

Web Development

Digital Marketing

Consumer Tech