Stored procedure to script out user permissions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Harsha Majety » Stored procedure to script out user...

Stored procedure to script out user permissions

Rate Topic

Display Mode

Topic Options

Author

Message

harsha.majety

Posted Saturday, January 15, 2011 2:10 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 6, Visits: 396

Comments posted to this topic are about the item Stored procedure to script out user permissions

Post #1048374

fahey.jonathan

Posted Wednesday, January 19, 2011 3:01 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 11, 2013 5:58 PM
Points: 100, Visits: 347

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

reefshark

Posted Monday, June 13, 2011 4:17 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:29 PM
Points: 58, Visits: 312

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 »

Permissions