Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshekar
Starting Member
49 Posts |
 Posted - 2005-04-05 : 16:05:49
|
| Hi,We have about 300 logins on our SQL server I need to get report for all my SQL server users, what kind of access they have..for example Update Access, insert/ delete Access on which object could any body about this..Thanks in advancechandra shekar |
|
|
Steve@3717
Starting Member
7 Posts |
Posted - 2005-04-05 : 17:15:11
|
| Hi Chandra.In qa, EXEC sp_helpuser will list all users in the current database. You can pipe the output to a flat file if need be... Hope it helps. -steve. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-05 : 21:18:24
|
| Also use sp_helprotect, it displays permissions by object and by user. |
|
|
|
|
|
|
SQL Security AUDIT