Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored procedure to script out user permissions Expand / Collapse
Author
Message
Posted Saturday, January 15, 2011 2:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 13, 2014 7:04 AM
Points: 9, Visits: 436
Comments posted to this topic are about the item Stored procedure to script out user permissions
Post #1048374
Posted Wednesday, January 19, 2011 3:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:46 PM
Points: 106, Visits: 369
This is a very helpful script; thank you for providing it.

Because most of our permissions are assigned by role, and individual users are assigned to roles, having a similar generator for permissions on a role would be helpful.
Post #1050409
Posted Monday, June 13, 2011 4:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 2:04 PM
Points: 58, Visits: 322
Hi - This is a very helpful script, however I noticed that it did not capture the custom role that I had created and added my user to. Any ideas as to why?

Thanks
Post #1124653
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse