Post reply

INFORMATION_SCHEMA

  • June 25, 2008 at 10:53 am

    #91991

    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

  • June 25, 2008 at 11:56 am

    #834190

    The users can SEE the INFORMATION_SCHEMA, but, they get DENIED when they query INFORMATION_SCHEMA if you deny SELECT on those SCHEMA.

  • June 25, 2008 at 12:25 pm

    #834201

    Thanks but can we deny VIEW DEFINITION. Somehow SQLServer2005 does not allow us to do that.

  • June 27, 2008 at 11:19 am

    #835527

    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?

  • July 1, 2008 at 4:42 pm

    #836949

    Thanks for the info. I have a developers that do not want its users to view the information schema.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply