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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-14 : 08:30:02
|
| Murtaza writes "How do I obtain the user access list from the System tables showing me the databases they have access to and the list of permissions on each database. Can you give an example. Thank You. regards Murtaza" |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-14 : 09:47:08
|
| Look at Book On Line under: System Stored Procedures. Scroll down to Security Procedures and look at all the ones that start with "sp_help". Everything you need is there.Be One with the OptimizerTG |
 |
|
|
|
|
|
User Access List