SQL Server Roles
How do you know what roles a user account have.
SELECT *
FROM (
SELECT LoginName = p.name
,AccountType = p.type_desc
,BulkAdmin = CASE WHEN IS_SRVROLEMEMBER('bulkadmin', p.name) = 1 THEN 'bulkadmin' END
,DBCreator = CASE WHEN IS_SRVROLEMEMBER('dbcreator', p.name) = 1 THEN 'dbcreator' END
,DiskAdmin = CASE WHEN IS_SRVROLEMEMBER('diskadmin', p.name) = 1 THEN 'diskadmin' END
,ProcessAdmin = CASE WHEN IS_SRVROLEMEMBER('processadmin', p.name) = 1 THEN 'processadmin' END
,[Public] = CASE WHEN IS_SRVROLEMEMBER('public', p.name) = 1 THEN 'public' END
,SecurityAdmin = CASE WHEN IS_SRVROLEMEMBER('securityadmin', p.name) = 1 THEN 'securityadmin' END
,ServerAdmin = CASE WHEN IS_SRVROLEMEMBER('serveradmin', p.name) = 1 THEN 'serveradmin' END
,SetupAdmit = CASE WHEN IS_SRVROLEMEMBER('setupadmin', p.name) = 1 THEN 'setupadmin' END
,SysAdmin = CASE WHEN IS_SRVROLEMEMBER('sysadmin', p.name) = 1 THEN 'sysadmin' END
FROM sys.server_principals p
WHERE TYPE IN ('U', 'S', 'G')
AND p.name NOT LIKE '%##%'
)Data
WHERE SysAdmin IS NOT NULL
ORDER BY LoginName, AccountType
On this page of the site you can watch the video online SQL Server Roles with a duration of hours minute second in good quality, which was uploaded by the user Afterowl 02 June 2017, share the link with friends and acquaintances, this video has already been watched 337 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
