Re: Viewing Role Permissions for Custom Role

ExcelMan (sfarkas@xxxxxxxxx) writes:
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?

Which version of SQL 2005 do you have? Specicially which version of
SSMS? I seem to recall that were some really crappy dialogs in this
area, but I just ran a test in SP2: I took a role, went to the Securables
tab, and added some tables and granted rights to some of them. I pressed
OK, and closed the dialog. When I opened the dialog again, and went to
the Securables tab, the objects I had granted rights to appeared.

But if you want to see which role you role is member of, you are out of
luck in that dialog. Use the query that Uri posted.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • 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: Securables for Application Role in Management Studio do not stick
    ... Select Add on the Securables panel ... that appears to be the essence of the resolution of these two bug reports: ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server 2005 security question
    ... Harold Shapiro writes: ... when he starts SQL Server Management Studio (logged in with his ... to see which securables PlainVanilla has access to. ... Which version of Mgmt Studio do you have? ...
    (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)
  • 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). ... permissions I granted to that role. ...
    (microsoft.public.sqlserver.security)