October 5, 2007 at 1:16 am
Guys just want to ask if:
db_owner
db_accessadmin
db_securityadmin
db_ddladmin
db_backupoperator
db_datareader
db_datawriter
db_denydatareader
db_denydatawriter
is equal to:
hasdbaccess
islogin
isntname
isntgroup
isntuser
issqluser
isaliased
issqlrole
isapprole
of sysusers. If not then were can i find the database user properties table
"-=Still Learning=-"
Lester Policarpio
October 5, 2007 at 2:16 am
Hmm, not sure I realyy understand your question but this is what I make of it. Your first list are all the fixeddatabase roles. In BookOnline you can find the description of which permission belong to which role.
The second list are prperties from the sysusers table which can apply to either a user or a role.
So db_owner is a role, which hasdbaccess and issqlrole.
User Markus can be isntuser or issqluser and islogin.
If you want to know the actual permissions of a role or user you need to include the tables syspermissions and sysprotects (or search for some scripts on this site).
Markus
[font="Verdana"]Markus Bohse[/font]
October 5, 2007 at 2:51 am
Ahh ok thanks for the clarification then i concluded the those database user properties are not equal to those values in the sysusers. The reason i asked this question is because i made a script that generates another script to add the database user properties of each database users. I based my script to those values in sysusers.
"-=Still Learning=-"
Lester Policarpio
October 5, 2007 at 3:08 am
Do you know any scripts that gets database users and their respective roles??
"-=Still Learning=-"
Lester Policarpio
October 5, 2007 at 12:18 pm
Not sure if this is what you were looking for.
the script in the following link should help you up to an extent.
http://qa.sqlservercentral.com/scripts/Audit/61175/
Regards,
Sathya.
October 7, 2007 at 6:49 pm
Got the link i need thanks....
qa.sqlservercentral.com/articles/Administering/listofdatabaseuserswithdatabaseroles/1545/
"-=Still Learning=-"
Lester Policarpio
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply