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-06-30 : 07:47:56
|
| michael writes "I have a VB project in which I have to collect info about users from the sql servers. The info that needs to be collected is 1) if the user has sql login, 2)has db acess, 3)roles that he has been assigned. Can this info be gathered without me have sa rights? I tried to run queries against the master db,but got access denied message." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-30 : 07:50:31
|
| This might help:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51770There are a huge number of sp_help procedures that provide a great deal of information, and should be the first place to start when you need to collect information about a SQL Server installation. Books Online has plenty of information on them. |
 |
|
|
|
|
|
collecting info about a user from sql server