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 |
|
heliang
Starting Member
38 Posts |
 Posted - 2008-12-12 : 10:29:34
|
| this is something new in SQL2005. I have a standard user who can not see other standard users in sysuser table. (it used to be able to see all users in sysuser table) This new change is creating a problem for us. Could you please help me fix this?Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-12 : 10:31:06
|
| Can you explain clearly so you get answer fast? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 10:32:09
|
| do you mean he doesnt have access to table sysusers? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
heliang
Starting Member
38 Posts |
Posted - 2008-12-12 : 16:01:23
|
| I have several standard users A, B, C, ....(not sysadmin). If I login as A and run "select * from sysuser" I only can see user A in this sysuser table. but in SQL2000, I can see all other users as well. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sysuer table