server roles
-
Hi Experts,
Is there any query in sqlserver to find all the server roles and their description.
TIA
-
select * from sys.server_principals
WHERE TYPE='R'
Description.. I am not sure SQL Server has any description associated... in any tables.. get that from Books Online...
Maninder
www.dbanation.com -
Yeah, the documentation inside sql itslef is lacking to the level of disappointment.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
But arent the roles self explanatory by their names.
Maninder
www.dbanation.com -
Somewhat, but their exact permissions aren't self-explanatory.
For instance, it's not a given what the difference between serveradmin and sysadmin is. That's not in the names of either one of them. And there's nothing about the name setupadmin that says it should have rights to alter linked servers, but it does.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
-
Hi ,
I found 'sp_helpsrvrole' which gives all server roles and description(full name):D
-
But Does that give you what you want? you mentioned something about the detailed description about what each role is about right.. and this function only extends the roles like sysadmin = System Administrators
securityadmin=Security Administrators. not much of a diff in admin and administrator etc.
Maninder
www.dbanation.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply