Informix Dynamic Server 14 - How to list users with DBSECADM role
Answered: amber (hollow confidence) — Andreas Legner points to the sysdbsecadmauth table (grantee column; DBSECADM is instance-wide). The asker then asks a follow-up about the Extend role, which goes unanswered.
Advisory only.
Posted in 2021
Topics: Security, Permissions & Auditing
Vincent Yip — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to Vincent Yip
Andreas Legner — source: IBM Community (ConnectedCommunity.org) Informix forum
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 ------------------------------
↪ replying to Andreas Legner
Vincent Yip — source: IBM Community (ConnectedCommunity.org) Informix forum
Hello! What about listing users with "Extend" role? Thanks, Vincent Yip