Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    32

    Unanswered: Procedure Privilages

    Hi
    This is on UDB verion 8.01.005
    How do I get to know the exiting Procedure Privilages

    As to which groups have access to execute the procedures.


    Thanks

  2. #2
    Join Date
    Sep 2003
    Posts
    85
    paehowun57:/home/insgipdm/sqllib> db2 describe table syscat.routineauth

    Column Type Type
    name schema name Length Scale Nulls
    ------------------------------ --------- ------------------ -------- ----- ------
    GRANTOR SYSIBM VARCHAR 128 0 No
    GRANTEE SYSIBM VARCHAR 128 0 No
    GRANTEETYPE SYSIBM CHARACTER 1 0 No
    SCHEMA SYSIBM VARCHAR 128 0 No
    SPECIFICNAME SYSIBM VARCHAR 128 0 Yes
    TYPESCHEMA SYSIBM VARCHAR 128 0 Yes
    TYPENAME SYSIBM VARCHAR 128 0 Yes
    ROUTINETYPE SYSIBM CHARACTER 1 0 No
    EXECUTEAUTH SYSIBM CHARACTER 1 0 No
    GRANT_TIME SYSIBM TIMESTAMP 10 0 No

    So, you could issue a select against syscat.routineauth with grantee.

Posting Permissions

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