Re: sp_helpsrvrolemember

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

johndoe_at_driver.net
Date: 10/28/04 

Date: Thu, 28 Oct 2004 03:23:38 -0500

I guess it seems that sp_helpuser returns this information
Now if i could just figure out how to find out if it is a member of the
"public"

<johndoe@driver.net> wrote in message
news:uZ5N7bMvEHA.3916@TK2MSFTNGP10.phx.gbl...
> Currently I am using sp_helpsrvrolemember to retrieve all of the users
> and their appropriate roles. Then I use a filter to grab an individual
> user. I am wondering if there is something I am missing. I am looking for
> (preferably) a sproc that takes a Windows/Sql Login and returns all of the
> roles that the user is a member of.
>
> From what I have read sp_helprole, sp_helprolemember,
> sp_helprsrvrolemember do not do what I need.Any help is appreciated.
>

Relevant Pages

  • Re: Tasks: Assigned To list is incorrect--Help?
    ... The person who was missing from the list had Web ... WSS is on a FE web server ... > rid of the person who is not even a member of the site. ...
    (microsoft.public.sharepoint.windowsservices)
  • Compiling 3.2.3 on AIX 5.2 using VAC 6.0 60day trial
    ... checking whether struct tm has member __tm_gmtoff__... ... checking for tgetent in -ltermcap... ...
    (SSH)
  • Nostalgia : Marco Polo
    ... All 7 episodes are missing :-( I read the novel and was impressed. ... John Lucarotti is a good author. ... Member - Liberal International ...
    (rec.arts.drwho.moderated)
  • Re: Herc and Russells Paradox
    ... the antidiagonal is missing from the range of the indexing ... will not appear within any finite set of subsets. ... = 1 IFF b is a member of the ath member of P ... This will enumerate all computable subsets of N. ...
    (sci.logic)
  • Re: Bagpipes
    ... "I'm already a member ... ... It seems to be missing the option for ... which enables you to just right click on the login box and ... automatically download a set of credentials which it plugs in for you. ...
    (uk.rec.sheds)