Re: How to hide INFORMATION_SCHEMA and sys from users

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




.

Relevant Pages

  • Re: How to prevent DELETEs in a table
    ... What you say about dbo is true, but it is even MORE true about someone who ... is in the sysadmin role. ... No permissions are ever checked for someone in the ... the deny is not applied. ...
    (microsoft.public.sqlserver.server)
  • Re: How to DENY SELECT permissions?
    ... You cannot DENY from sysadmin. ... "Lawrence" wrote in message ... > I'm dbo & sysadmin on this table that I'm trying to take away SELECT permission. ...
    (microsoft.public.sqlserver.programming)
  • Re: DENY ALL for all tables
    ... To the best of my knowledge the default is NO permissions. ... > but it only works on tables belonging to the dbo owner. ... > one table at a time like DENY ON owner.tablename TO ...
    (microsoft.public.sqlserver.security)
  • How to DENY SELECT permission?
    ... I am dbo and sysadmin on this table that i'm trying to deny SELECT permission. ...
    (microsoft.public.sqlserver.programming)