Re: Permissions List

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/28/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Fri, 28 Jun 2002 13:42:08 -0600

Just to add to the list...
NT group members can be obtained with:
exec xp_logininfo 'Domain\GroupName', 'members'
And role members (what if the users have db_datareader, etc)
exec sp_helprolemember 'db_ddladmin'
Don't think there is a single command to get a
comprehensive, all inclusive list of those with direct as
well as inherited permissions.

-Sue

On Fri, 28 Jun 2002 10:08:58 -0700, "Alan Roberts"
<taroberts@gcc.edu> wrote:

>How can I get a printable list of all users who have
>access to a particular table?

Relevant Pages

  • Re: how does an exec meeting work?
    ... The exec should be very very keen on you attending. ... The Group Scout Council is the electoral body, ... Group Scout Fellowship members; ... the maintenance of the Group's property and equipment; ...
    (uk.rec.scouting)
  • Re: problems with leaders - advice appreciated
    ... >>> Go check your constitution regarding the position of your Exec members. ... The chairman has no more say in fiscal matters than ... I do believe it because that is how an effective committee works. ...
    (uk.rec.scouting)
  • Re: Big problem fetching members from dynamically loaded module
    ... > make your program harder to understand and more likely to fail in obscure ... and I want their members in the menus if they are installed. ... > to ensure that evaland exec share the same namespace. ...
    (comp.lang.python)
  • Re: If you could....
    ... up nominations each year who are preferably not uniformed members. ... In the past we had a large exec too. ... to ask for nominations from Groups - I think that stopped a long time ago. ... many and it was getting like a leaders meeting with too much of that being ...
    (uk.rec.scouting)
  • Re: If you could....
    ... We have a fairly large exec. ... The more non-uniformed members the better and all the ADC's attend as well but we stick to the agenda and have separate ADC meetings so that the Exec can focus. ...
    (uk.rec.scouting)