Post reply

db reader access

  • August 6, 2008 at 3:27 pm

    #210912

    guys,

    Is there anyway restrict read only user with db_reader not have to any select privileges on all the system tables like sysobjects,

    information_schema.columns etc.

    Thanks

  • August 6, 2008 at 3:37 pm

    #854148

    You may look at DENYing select access to the user through the SCHEMA's sys and INFORMATION_SCHEMA. If denied select access to those schemas they should theoretically not have access to the system tables and views.

    Haven't tried it, so I would be interested to know if it works.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

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