Informix

Expand all | Collapse all

Informix Dynamic Server 14 - How to list users with DBSECADM role

  • 1.  Informix Dynamic Server 14 - How to list users with DBSECADM role

    IBM Select
    Posted Tue July 06, 2021 12:31 AM
    There are no results from SELECT * FROM sysroleauth, or SELECT * FROM syssurrogates or SELECT * FROM sysusers
    after granting user DBSECADM.

    Any one knows how to get the list of users with this Database Security Administrator (DBSECADM) role?

    Thanks

    ------------------------------
    Vincent Yip
    ------------------------------


  • 2.  RE: Informix Dynamic Server 14 - How to list users with DBSECADM role

    IBM Select
    Posted Tue July 06, 2021 04:11 AM
    sysuser:sysdbsecadmauth table is what you're looking for (grantee field only, database field looking to be unused as DBSECADM role is instance wide).

    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: Informix Dynamic Server 14 - How to list users with DBSECADM role

    IBM Select
    Posted Tue July 06, 2021 06:06 PM

    Hello!

     

    What about listing users with "Extend" role?

     

    Thanks,

    Vincent Yip