October 28, 2008 at 3:30 pm
How can I hide the system tables (sys and INFORMATION_SCHEMA) from users? I am not talking about Management Studio. We have users who access the database with ODBC and I do not want them to see all these system tables.
Does anyone have any suggestions on where I have to go to remove all the places that give users access to these tables?
October 28, 2008 at 7:54 pm
I believe DENY VIEW DEFINITION will do the trick for most things.
Here's the MSDN article that will explain what you can and can't do with it.
http://msdn.microsoft.com/en-us/library/ms187113(SQL.90).aspx
Craig Outcalt
October 28, 2008 at 9:59 pm
I try giving DENY VIEW DEFINITION at the database level and having the same issue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy