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 |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2005-08-16 : 12:24:49
|
| I was just setting up a DSN (via MS Access) on someone's desktop and noticed that when I went to list the objects this user had access to on the SQL Server, not only did the expected objects show up, but the list of INFORMATION_SCHEMA views showed up as well.The same question goes for SYS... base tables, I notice PUBLIC has SELECT permissions on many of these as well.Is there any reason an end user would need access to these views? I removed access.thx |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-08-17 : 16:24:18
|
| No real reason, but I don't see a lot of harm, either. The only big caution would be the syslogins table, which has encrypted passwords, but that pretty much comes down to how much you trust the honesty (or technical savvy) of your users ;-). |
 |
|
|
|
|
|
INFORMATION_SCHEMA, does PUBLIC need access?