13 June,2014 by Tom Collins
Question: How can I determine if a user has SYSADM or SYSCTRL authorization?
I've read the DB2 - A Security Primer , but couldn't locate any commands
Answer: Use the AUTH_LIST_AUTHORITIES_FOR_AUTHID table function. The function has replaced the get authorizations command. The function returns authorities granted to an ID directly or indirectly
Return authorities granted to user JACK , either explicitly or via a role or group
SELECT AUTHORITY, D_USER, D_GROUP, D_PUBLIC, ROLE_USER, ROLE_GROUP, ROLE_PUBLIC, D_ROLE FROM TABLE (SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID ('JACK', 'U') ) AS T ORDER BY AUTHORITY
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |