Stored procedure to script out user permissions

Question

Stored procedure to script out user permissions

harsha.majety

SSCommitted

Points: 1537
More actions
January 15, 2011 at 2:10 pm

#245362

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

fahey.jonathan Hall of Fame Points: 3617 More actions · Answer 1

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.

reefshark Ten Centuries Points: 1340 More actions · Answer 2

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

May 17, 2016 at 7:00 am

#1879516

Another good one Harsha.