SQL Server Performance Forum – Threads Archive
How to check logins previlege( permission)
I know it’s easy to check the permission for one user on the proprities tab but can I generate one list contains all users and their relevant privileges? syspermissions table seems not enough to get such info from. thanks a lot!Check syslogins table in the master database sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server role.
serveradmin int 1, if login is a member of the serveradmin fixed server role.
setupadmin int 1, if login is a member of the setupadmin fixed server role.
processadmin int 1, if login is a member of the processadmin fixed server role.
diskadmin int 1, if login is a member of the diskadmin fixed server role.
dbcreator int 1, if login is a member of the dbcreator fixed server role.
sorry it is a view
[B)]
quote:Originally posted by dineshasanka
Check syslogins table in the master database
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server role.
serveradmin int 1, if login is a member of the serveradmin fixed server role.
setupadmin int 1, if login is a member of the setupadmin fixed server role.
processadmin int 1, if login is a member of the processadmin fixed server role.
diskadmin int 1, if login is a member of the diskadmin fixed server role.
dbcreator int 1, if login is a member of the dbcreator fixed server role.
securityadmin int 1, if login is a member of the securityadmin server role.
serveradmin int 1, if login is a member of the serveradmin fixed server role.
setupadmin int 1, if login is a member of the setupadmin fixed server role.
processadmin int 1, if login is a member of the processadmin fixed server role.
diskadmin int 1, if login is a member of the diskadmin fixed server role.
dbcreator int 1, if login is a member of the dbcreator fixed server role.
thanks for your info. That helps. Besides, I need a checklist of user privilege which includes all related objects for example the read privilege on one table but read&update privilege on another table. anyone can give me clue? Thanks a lot!
SP_HELPROTECT lists all the privileges held by the users in the database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
that’s cool. Thank you very much, Satya.
]]>