Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  role granting

    Posted 06/08/21 04:20 AM
    is there in db2 luw a view/tablefunction/sql that could list you all grants that have been given to a role
    or do you need to combine individual tables as sysibm.systabauth sysibm.sysroles  and select granteetype='R' and join on roleid to find tablegrants and repeat this for other objects

    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: role granting

    Posted 06/09/21 02:47 AM
    See if SYSIBMADM.PRIVILEGES fits your needs

    select * from SYSIBMADM.PRIVILEGES
    where AUTHIDTYPE = 'R'
    and ...

    https://www.ibm.com/docs/en/db2/11.5?topic=views-privileges-privilege-information




  • 3.  RE: role granting

    Posted 06/09/21 03:14 AM
    thanks for the update - yes that will do

    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    Original Message


Related Content