Results 1 to 7 of 7

Thread: Deny login

  1. #1
    Join Date
    Apr 2005
    Posts
    40

    Unanswered: Deny login

    I wanted to deny all from being able to access a particular table, except one particular person. What is the best way to do this?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    How does everyone authenticate tot he database? Via windows authentication, or by a single application ID?

  3. #3
    Join Date
    Apr 2005
    Posts
    40
    windows authentication.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Since everyone is coming in with different IDs, this should be easy enough. Create a role in the database for all of the other logins. Deny access to the table for this role. Ideally, you can create a role for the other person (in case he gets an assistant), and grant permissions to that role on the table.

  5. #5
    Join Date
    Apr 2005
    Posts
    40
    Right, I wanted to create a new database role called, Test, and assign one person to this role, then assign this role to the table, so that this one person can access the table, and deny the public role to this table. But, in denying the public role, seems like only a sysadmin can access the table.......so how does creating the role test work? For the best way to go about this....What are the steps to deny everyone in the database access to the table, except one person?

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Public is a built in role. Everyone is a member of the public role. Including the person you want to give access to. You will need to create a second role for "everyone else".

  7. #7
    Join Date
    Apr 2005
    Posts
    40
    ok, got it-thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •