Roy Ashbrook

let go or be dragged
posts - 198, comments - 29, trackbacks - 8

September 2008 Entries

find sql users and roles assigned to my databases

thanks to this article for the base script. i needed to get a list of all users and the roles they had in each db. this script is great in that you can use the raw base script (mine is slightly modified) and list things for every object instead of just at the db level. in my case and in most people's case i imagine that makes this dataset rather large. this allowed me to get a large union on the raw data i needed for all of the databases and then i could put it one table so i...

posted @ Friday, September 5, 2008 7:19 PM | Feedback (0) | Filed Under [ DBA ]

Powered by: