SQLTeam.com | Weblogs | Forums

Get olap role


#1

hi

i want to get all users role to table by sql.
how can i do it?


#2

I do not remember where I got this: -- Who has what general permission SELECT a.name as LoginName,a.type_desc AS LoginType, a.default_database_name AS DefaultDBName, CASE WHEN b.sysadmin = 1 THEN 'sysadmin' WHEN b.securityadmin=1 THEN 'securityadmin' WHEN b.serveradmin=1 THEN 'serveradmin' WHEN b.setupadmin=1 THEN 'setupadmin' WHEN b.processadmin=1 THEN 'processadmin' WHEN b.diskadmin=1 THEN 'diskadmin' WHEN b.dbcreator=1 THEN 'dbcreator' WHEN b.bulkadmin=1 THEN 'bulkadmin' ELSE 'Public' END AS 'ServerRole' FROM sys.server_principals a JOIN master..syslogins b ON a.sid=b.sid WHERE a.type <> 'R' AND a.name NOT LIKE '##%' ORDER BY serverrole, 1


#3

i need OLAP role,(not sql role server)

thanks