SQL Server Performance Forum – Threads Archive
Need a query to know who has write access to dbs
HiI need the list of NT users or groups who can write to a number of dbs on a server.
can somebody help me with a t-sql on this… regards
Suleman
EM or Managment Studio give you this information.
For some reason do you need a T-sql? Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
Hi Martin As far as i know we can get the list of all users or NT groups irrespective of the permissions they have… But i need a list of all users or NT Groups which have the write access to a few dbs … Regards
Suleman
Check SP_HELPROTECT procedure output….
Mohammed U.
]]>