Post reply

Restrict read only access to one table in a database

  • June 10, 2009 at 10:43 am

    #138594

    How do I restrict a user to only have access to one table in a database. I have set up a Read Only UID that only allows access to a specific database. I have been asked if there is a way to further restrict that user to be able to only query from one specifc table in that database.

  • June 10, 2009 at 11:28 am

    #1007583

    Perhaps I missing something but...

    create a login for the user

    grant access to the user database

    grant select on . to

  • June 10, 2009 at 11:48 am

    #1007595

    I had created the user and gave access to the database. I did find the further permission restriction at the table level. Thanks.

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

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