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