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 |
|
QuietRiot
Yak Posting Veteran
67 Posts |
 Posted - 2008-06-02 : 19:04:35
|
| I'm new to this. But, basically I was given an admin login/password , but for the most part everyone else uses a trusted connection (windows auth.) to login into query analyzer.today we noticed that for 1 particular database a user couldn't view anything from a specific table but I was obviously.how can I get this information so I can give our dba a list of tables he needs to give us read access too. I suppose I could ask the DBA but I wouldn't learn anything and it would prolong this for weeks most likely.I want either a list of users or roles or all tables that have just read access (because thats all they should have). |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 20:17:16
|
| Besically you have to look at all tables in the db and find out which ones that user needs access, sql server can't tell you that. |
 |
|
|
leena
Starting Member
6 Posts |
Posted - 2008-06-05 : 16:06:55
|
| ask dba to use sp_helpprotect to see individual roles.. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 16:11:03
|
quote:
Originally posted by leena
ask dba to use sp_helpprotect to see individual roles..
Its sp_helprotect |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-05 : 22:21:19
|
| It only tells which object the user has permission but not which object user needs to access. |
|
|
|
|
|
|
list of users/roles