hiding Information_schema and sys from ODBC users RRS feed

  • Question

  • I am using MSSQL Server 2005 and I want to hide the information_schema and sys from ODBC users, it will just confuse them.  I have tried deny permission on View Definition of the schemas in the database but it does nothing.  Can this be done?  I have scoured the web for an answer to no avail.  All the threads on this end with no answer.
    Friday, May 22, 2009 8:00 PM

All replies