cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2881
Views
0
Helpful
2
Replies

Security Audit: Why dosn't the dbo.secmst display the SUPERUSER as a Security Policy Type

jeff.hamway01
Beginner
Beginner

Hello Admins,

Every quarter,  we do  a security audit as part of or SOX compliance.  I noticed that the SuperUsers are not listed when I pull my report.

select dbo.usrmst.usrmst_fullname, usrmst_name, dbo.secmst.secmst_name
from dbo.usrmst
join dbo.secmst ON usrmst.secmst_id = dbo.secmst.secmst_id
order by usrmst_fullname asc

Does anyone have a script that actually shows who has superuser access? 

Thanks

Jeff

1 Accepted Solution

Accepted Solutions

brian_dickens
Beginner
Beginner

superuser rights are kept in a different column. I don't know why this is.

Column is usrmst_suser.

Values are Y, N, R, P.

Looks like Y indicates an interactive login with superuser rights. R is a runtime user. I don't have any records with a P value so I can't tell what that is. I think what you're looking for is usrmst_suser = 'Y'

View solution in original post

2 Replies 2

brian_dickens
Beginner
Beginner

superuser rights are kept in a different column. I don't know why this is.

Column is usrmst_suser.

Values are Y, N, R, P.

Looks like Y indicates an interactive login with superuser rights. R is a runtime user. I don't have any records with a P value so I can't tell what that is. I think what you're looking for is usrmst_suser = 'Y'

Thank you Brian,

I have updated my script to be more functional.  Much Appreciated. Hope this helps some other people.

select dbo.usrmst.usrmst_fullname as 'Full Name', usrmst_name as 'User Name', dbo.secmst.secmst_name as 'Security Profile', usrmst_suser as 'Super User'

from dbo.usrmst

join dbo.secmst ON usrmst.secmst_id = dbo.secmst.secmst_id

where usrmst_suser = 'y' or dbo.secmst.secmst_name like '%%'

order by usrmst_fullname asc

 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers