January 25, 2012 at 1:34 pm
I need a script that will script out the database roles and permissions on objects for a particular user.
Blog
http://saveadba.blogspot.com/
January 25, 2012 at 1:51 pm
there are a number in the scripts section of this site - do a search under 'permissions'
---------------------------------------------------------------------
January 25, 2012 at 2:23 pm
http://www.google.com/search?q=script+database+roles+and+permissions
-- Gianluca Sartori
January 25, 2012 at 2:31 pm
I prefer this site for that sort of thing. 😉
http://www.lmgtfy.com/?q=script+database+roles+and+permissions
January 25, 2012 at 4:11 pm
I'd ensure you get a version designed for SQL2005 and up.
you don't say whether you want to reverse engineer the code or just get a list of permissions but to get you started here is a shameless plug for my own code. It is designed to list all users but you could adapt it. Read the discussion as well
http://www.sqlservercentral.com/scripts/Permissions/76450/
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply