Re: How to hide INFORMATION_SCHEMA and sys from users

Dear Hongju:

Sorry, but your answer does not make sense. I too am having the same issue:
Using an ODBC connection, users can see all system objects in the
INFORMATION_SCHEMA, and sys schemas. I have tried DENY permissions on View
Definition at all scope levels but still the users can see all these views
using ODBC.

What am I missing?

Can you elaborate on your answer?
Does anyone else have any suggestions?

Thanks in advance.

Todd C

"hongju" wrote:


Yes, see but non select values.
I said that dont view serveral user objects.
Dont support to hide permission on system objects, but not result.


"christophe.leroquais@xxxxxxxxx"님이 작성한 내용:

hongju:

I've tried:

DENY VIEW DEVINITION TO 'myUserName'

at the database level but it is without any effect.
The user still can see all the dbo, INFORMATION_SCHEMA and sys objects



hongju a écrit :

You can deny a permission using VIEW DEFINITION clause.
Users dont view that in Management studio.


"Bill Blakey"님이 작성한 내용:

There's a system procedure that Crystal Reports (for example) invokes upon
connection to a SQL Server database: sp_schemata_rowset

In SQL 2005 this returns the three default Schemas:
dbo
INFORMATION_SCHEMA
sys

I'm trying to suppress/hide the last two Schemas but am not having any luck.
Is it possible to not expose Schemas to users in SQL 2005 (their existence
at all)? Revoke and Deny of various permissions does not seem to be working
(including View Definition which I thought would do it)...

TIA

--

Bill Blakey





.