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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-08-06 : 17:28:27
|
| guys,Is there anyway restrict read only user with db_reader not have to any select privileges on all the system tables like sysobjects, information_schema.columns etc.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-06 : 17:45:09
|
| I'm not sure that you can DENY these. Have you tried granting only SELECT on the objects that you want them to read? But if I recall correctly, you can't prevent this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-06 : 23:37:50
|
| Since public role has those permissions. |
|
|
|
|
|
|
db reader access