We have a request from client to hide all system views/tables from users in SQL server 2005.
As user assigned to a specific database role, client do not want the user to see all system tables and INFORMATION_SCHEMA views, so they can have a clear view for only user tables in their schema.
However, whenever they connect using Access via ODBC they get a huge list of sys and INFORMATION_SCHEMA views.
Also when connecting from SQL Management Studio, they are getting same list.
We have taken following steps, but no luck.
1. DENY permissions on "View Definition" at all scope levels but still the users can see all these views using ODBC.
2. Tried denying access by changing permissions to deny in the public role, but still the same.
3. Created one Role including deny permissions to all sys and INFORMATION_SCHEMA views and assigned to user, but same issue.
Please advise is there any way of doing it
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]