Db2 (On Premises and Cloud)

Expand all | Collapse all

role granting

  • 1.  role granting

    Posted Tue June 08, 2021 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
    ------------------------------


  • 2.  RE: role granting

    Posted Wed June 09, 2021 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 Wed June 09, 2021 03:14 AM
    thanks for the update - yes that will do

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