Viewing Role Permissions for Custom Role

I set up a custom role "Finance" and assigned it a combination of some
built-in roles and some specific permissions to specific objects
(securables). However when I go back into the role and look at the
properties of that role, I do not see a list of the specific object
permissions I granted to that role.

Instead I seem to have to go back to those objects, Add them in again,
and then I see that they were already selected.

Is there a place I can see the objects/permission I already granted to
a custom role?

Thanks.

Steven

.

Relevant Pages

  • Re: Viewing Role Permissions for Custom Role
    ... select r.name as Role, m.name as Member ... built-in roles and some specific permissions to specific objects ... permissions I granted to that role. ...
    (microsoft.public.sqlserver.security)
  • RE: Roles based security 2005 versus 2000
    ... Right-Click on the Database Role and select Properties ... In the Properties Dialog select the SECURABLES page ... Product team remove this feature to optimize the ... active and if you try to grant the permissions again by select the ...
    (microsoft.public.sqlserver.security)
  • Re: Viewing Role Permissions for Custom Role
    ... permissions I granted to that role. ... area, but I just ran a test in SP2: I took a role, went to the Securables ... the objects I had granted rights to appeared. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Overlapping Permissions
    ... There's the Domain Users and two other non-NT, SQL Server accounts for web ... There are no other roles other than the built-in roles. ... select, insert, update and delete permissions. ...
    (microsoft.public.sqlserver.security)
  • Explicit permissions listed twice
    ... Properties for a particular user, and select the Securables page, each of ... that were granted by "dbo" do not have Grant, With Grant, or Deny checked. ... Should I remove the explicit permissions that were granted ...
    (microsoft.public.sqlserver.security)