Results 1 to 4 of 4

Thread: ROLE_Dilemma

  1. #1
    Join Date
    Dec 2003
    Location
    Lowlands
    Posts
    53

    Unanswered: ROLE_Dilemma

    Hi folks,
    I was wondering if anyone ever tried to assign a role to a user and then while the role specifies that the user has delete access, still restrict the delete access for that user, without removing the role from the user.
    I want to know if it is possible and if you can tell me how it would perfect.

    thanx anyway
    Last edited by StylizIT; 12-04-03 at 11:24.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I think you can bring up the Manage Permissions dialog for the object and specifically deny access to a particular user (or another role). The box should have a large red X in it, and the "Deny" trumps "Allow" if there is a conflict for a user assigned to more than one role or with special permissions.

    blindman

  3. #3
    Join Date
    Dec 2003
    Location
    Lowlands
    Posts
    53
    Hi Blindman,

    can you (or anyone else) please explain how i should do this. I have always been working with PostgreSQL, so I'm very new to MS SQL.

    thnx anyway for the tip

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Right-click on your table in Enterprise Manager and select All Tasks, Manage Permissions.

    You will see a window listing users and roles, and their permissions on the table. Click a permission box once and a green check-mark appears, indicating the permission is granted. Click again and a red X appears indicating the permission is revoked. Click one more time and the box is cleared, indicating the the user has whatever permission is default or is defined by another role to which the user belongs.

    blindman

Posting Permissions

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