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: 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)
  • Re: How to use a Group Distribution list inorder to send and received messages
    ... In the Permissions list, locate Send As, and then click to select the ... permission of the user account that is a member of one of administrative ... groups will be reset to match the ACL of the AdminSDHolder thread. ... Directory domain controller that holds the primary domain controller ...
    (microsoft.public.exchange.admin)