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

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 ------------------------------ #Informix

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 ------------------------------

Hello! What about listing users with "Extend" role? Thanks, Vincent Yip