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 ««12

Database User and Roles Script Extract Needed Expand / Collapse
Author
Message
Posted Wednesday, April 3, 2013 7:12 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:03 PM
Points: 968, Visits: 966
logicinside22 (3/28/2013)
Hi
I am looking for same script to generate script for User DB roles . Can you share if you have it now?
Or if anyone have it can share ?
Thanks


I think the script I have posted here should work. I just created an empty DB, added a table, added a new role, and issued a "grant select on dbo.table1 to test_role" and then executed the script.

The output I got back was under object level permissions for that role:
-- [-- OBJECT LEVEL PERMISSIONS --] --
GRANT SELECT ON [dbo].[table1] TO [test_role1]



Check that out and let me know if something is missing there.

Cheers,
Steve
Post #1438633
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse