Martin Balbo
SSC Eights!
Points: 874
More actions
February 6, 2006 at 8:36 am
#111740
Hi Friends.... i have a requirement from the audit department. They need a list which contains:
User, database, dbrole
Can anyone help me to make a script to do this? I have 200 users on my SQL2000 Server.
Thanks in advance.
CTracy
Points: 903
February 6, 2006 at 10:00 am
#619014
A while back Chad wrote an column using DumbSQLSec. I've played around with it a little bit and might work for what you need. Here is the column http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp
-c
February 6, 2006 at 10:26 am
#619025
This works great... Thanks for help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply