Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    33

    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.

    Thanks
    Ron

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •