SQL Server Performance Forum – Threads Archive
Need a query to know who has write access to dbsHi
I 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
EM or Managment Studio give you this information.
For some reason do you need a T-sql? Luis Martin
SQL-Server-Performance.com All in Love is Fair
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
Check SP_HELPROTECT procedure output….