February 22, 2010 at 11:56 am
I have a situation in which a SQL login needs read permission on dozens of databases. Ideally, I could create a server role. Then I could add the login to that role, and give the role all the database permissions. This is similar to how I handle Windows AD groups & users.
I can create a database role in each database and add the sql login to each db role, but hoping for a better idea.
Thoughts ?
February 22, 2010 at 2:53 pm
There's nothing like custom Server roles in 2005+. I would suggest writing a tool or sproc to map a Login to a set of databases for you automatically.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 22, 2010 at 3:01 pm
I don't see any other way - you have to create the user(s) in the database before you can assign any permissions to the user.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply