Re: Viewing Role Permissions for Custom Role

Hi
select r.name as Role, m.name as Member
from sys.database_role_members rm
join sys.database_principals r on rm.role_principal_id = r.principal_id
join sys.database_principals m on
rm.member_principal_id = m.principal_id
order by r.name, m.name




"ExcelMan" <sfarkas@xxxxxxxxx> wrote in message
news:1180307044.248019.135800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • 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)
  • Re: Changing groups
    ... pleaderb, sue, frank, ed are members of group projectb ... Everyone is a member of group user. ... depending on the file's permissions they can read and write the ... I do this all the time, using Samba. ...
    (Debian-User)
  • Re: Outside Users RDP into WS2008???
    ... Name it DL-Consultants ... Assign permissions on a resource to domain local group '. ... add any user account belonging to your consultants to become member of G-Consultants group. ... End disconnected session: ...
    (microsoft.public.windows.server.general)
  • Re: How to remove a user from a mail group (Tried to search...)
    ... If you're using Distribution Groups, these cannot show up in any ACLs ... If it is a Security Group, you'll need to figure out the what different ... resources the group could have permissions on. ... I go to "member of" tab. ...
    (microsoft.public.exchange.admin)