User Defined Server Roles

Question

User Defined Server Roles

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
August 8, 2013 at 8:18 pm

#75680

Comments posted to this topic are about the item User Defined Server Roles

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Easy one to finish the week, thanks Steve!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Koen Verbeeck (8/8/2013)
Easy one to finish the week, thanks Steve!

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Dave62 SSCertifiable Points: 7459 More actions · Answer 3

User defined server roles looks interesting. Thanks for the question Steve.

A minor correction is needed on the reference. It points to fixed server-level roles not user defined and includes earlier versions of SQL Server.

The correct documentation should be: http://technet.microsoft.com/en-us/library/ee677610.aspx

Interestingly, I could not find a reference for 2014 so the correct answer may be 2012 instead of 2012 and above. More likely though is that the 2014 documentation isn't complete yet.

Enjoy!

Edit: It took a little longer but here's the reference for 2014 and 2012.

http://msdn.microsoft.com/en-us/library/ee677610(v=sql.120).aspx

Dana Medley SSCertifiable Points: 6764 More actions · Answer 4

Thanks for the easy one Steve!

Everything is awesome!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 5

TGIF! Thanks for the question. Wouldn't mind more on user/role management.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

Dave62 (8/9/2013)
User defined server roles looks interesting. Thanks for the question Steve.
A minor correction is needed on the reference. It points to fixed server-level roles not user defined and includes earlier versions of SQL Server.
The correct documentation should be: http://technet.microsoft.com/en-us/library/ee677610.aspx
Interestingly, I could not find a reference for 2014 so the correct answer may be 2012 instead of 2012 and above. More likely though is that the 2014 documentation isn't complete yet.
Enjoy!
Edit: It took a little longer but here's the reference for 2014 and 2012.
http://msdn.microsoft.com/en-us/library/ee677610(v=sql.120).aspx

Thanks for the link. I've updated the explanation.

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 7

Good easy question on new TSQL functionality... Thanks Steve! 😎

sqlnaive SSCoach Points: 17437 More actions · Answer 8

Nice easy question. Keen to check this functionality out in SQL 2012. 🙂