January 3, 2007 at 4:08 am
Dear all!
I'm looking for convenient way to generate script for re-creation of user roles, OLPs for all databases on server.
Task Example: Add new user with exact roles/permissions as the existing one.
Thanks in advance,
Alex.
January 3, 2007 at 6:48 am
script out your sql server login with the object level permissions and use that script to create your new login
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 4, 2007 at 2:18 am
And from all databases on server in one shot and not one-by-one?
When scripting out the user from the server you get only it's definition without any databse realted info.
January 4, 2007 at 6:27 am
I hope the script in this link http://www.sqlservercentral.com/scripts/contributions/1598.asp will solve your issue.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 6, 2007 at 2:14 am
Thank you, Sugesh!
I'll try this.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply