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 |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2009-11-03 : 12:05:36
|
| In SQL 2005/2008, how can I grant SELECT permissions on Sysusers to Public so that all users can see the list of database users? It seems it is now in the catalog sys.database_principals and the metadata view is restricted according to the individual user's login. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-03 : 13:26:48
|
| http://msdn.microsoft.com/en-us/library/ms187113.aspx |
 |
|
|
|
|
|
Permission on Sysusers