March 9, 2011 at 9:59 pm
Hi All,
Could any one give me t-sql script regarding what are the user permissions on all databases in a single instance.
Thanks To All
Regars,
Rekha.
March 9, 2011 at 10:37 pm
Not going to provide you with a full working script, but only some directions...
make use of:
syslogins
syspermissions
sys.database_permissions
sysusers
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 22, 2012 at 8:45 am
plenty of example scripts on this site you can tweak to meet your needs
try this one
http://www.sqlservercentral.com/scripts/permission/76841/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply