How to script User define database role

Question

How to script User define database role

Vasu-709835

SSC Eights!

Points: 921
More actions
February 16, 2010 at 9:34 am

#216914

Hi Every one,
I am having user defined db role called asp_roles
but how can come to know what permissions given in that role?
Can i get any script to script the user defined roles to find the permissions?

Viewing 2 posts - 1 through 1 (of 1 total)

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

You can find lots of scripts by searching this site. Here's one I've used: http://www.sqlservercentral.com/Forums/Topic436343-359-1.aspx. You can also see the object permissions of a role in SSMS by looking at it's properties and selecting the 'Securables' page.

Greg