April 22, 2014 at 9:49 am
I am looking for a short piece that shows how to check if a user is a member of a database role? Please show built in and user defined roles. Also, show how to query for all the database roles that a user is a member of.
This should be 1-2 pages, a short tutorial.
April 22, 2014 at 10:20 am
I can take this one.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 22, 2014 at 10:33 am
Take it. I prefer that you get one done before doing another, but since this and the server one are very similar, do them both.
You can use the same style/template/language in both for the most part if you like.
April 22, 2014 at 10:39 am
Will do. Is there any preference if I show this in T-SQL and in PowerShell, or you prefer just T-SQL?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 22, 2014 at 1:47 pm
Both are fine. Include some scenarios/examples, so that someone not sure how to do this understands what they are doing here.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply