Tags: sys.server_role_members

Which login has what server role permissions

Jan 31st

Posted by Torsten Schuessler in SQL Server

No comments

Below script will query sys.server_role_members / sys.server_principals to find out which logins have what server role access.SELECT 'ServerRole' = CASE WHEN rm.role_principal_id > 2 THEN SUSER_NAME(rm.role_principal_id)… more »
sql server, sys.server_principals, sys.server_role_members, t-sql

Schlagwort-Wolke

backup «best practices» bginfo book books «cumulative update» datetime dba disk dm_db_index_operational_stats dmv humor index indexoptimize integrity links loginproperty maintenance mcts «ms connect» «ms sql server 2008» performance php «plan cache» profiler «reporting services» reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack «system databases» t-sql «technical note» tools troubleshooting weekend whitepapers «windows server 2003» xp_msver