Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

INFORMATION_SCHEMA Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2008 10:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 3:27 PM
Points: 41, Visits: 46
Hello,
I would like to DENY VIEW to INFORMATION_SCHEMA to certain users and I tried to DENY SELECT and DEFINATION VIEW to INFORMATION_SHCEMA to a group of users, but they are still able to see the INFORMATION_SCHEMA.
Any idea why this is not working and how can we DENY VIEW to INFORMATION_SCHEMA to a group of users.
Thanks Farhad
Post #523551
Posted Wednesday, June 25, 2008 11:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 7, 2014 12:18 PM
Points: 413, Visits: 1,438
The users can SEE the INFORMATION_SCHEMA, but, they get DENIED when they query INFORMATION_SCHEMA if you deny SELECT on those SCHEMA.
Post #523604
Posted Wednesday, June 25, 2008 12:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 3:27 PM
Points: 41, Visits: 46
Thanks but can we deny VIEW DEFINITION. Somehow SQLServer2005 does not allow us to do that.
Post #523618
Posted Friday, June 27, 2008 11:19 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 7, 2014 12:18 PM
Points: 413, Visits: 1,438
By default, every one (in public role) can see it. But, not every one can query against it.

And, those INFORMATION_SCHEMAs are on BOL. So, what's your purpose of denying that public knowledge?
Post #525212
Posted Tuesday, July 1, 2008 4:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 3:27 PM
Points: 41, Visits: 46
Thanks for the info. I have a developers that do not want its users to view the information schema.

Post #526956
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse