Re: Permissions

sp_helprotect will also let you find rights directly assigned to a user that
were not assigned through a role. It can also be used to enumerate the
object rights granted to a role.

(Are you on SQL Server 2000?)

RLF

"moharil" <sid_m15@xxxxxxxxx> wrote in message
news:B9F6F4E9-1903-4C8A-BE61-4AD58D274A56@xxxxxxxxxxxxxxxx
i think this should help right is there anything else that we can do ?

sp_helprolemember and sp_helpsrvrolemember
--

-SQL Nebie





Hi ,

I need to find out which are the System generated list of accounts and
what
all permissions are granted to these login in the PROD DB .

Also what roles are assigned to which accounts

Regards

-SQL newbie



.

Relevant Pages

  • Query for AD to get E-mails With User Accounts & Creating New user Accounts !!
    ... i'm a newbie in Exchange Server who has it as heritage from a previous ... accounts associated with each user account .. ... 7- the delivery option to forward e-mail (the ability to spcify the ... The Exchange Newbie :-) ...
    (microsoft.public.exchange.admin)
  • Permissions on global catalog in test domain
    ... I have a testdomain with a one-way, external trust to our production domains ... (prod accounts can log into test, but not the other way around). ... be contacted to retrieve the icons for the member list because access was ...
    (microsoft.public.win2000.security)
  • Enumerating mail accounts and getting account information?
    ... I'm trying to enumerate all the mail accounts ... The XML provisioning API doesn't let you get at ... accounts the user has setup themselves through the mail UI. ...
    (microsoft.public.pocketpc.developer)
  • Re: Can FIBS rep-bot be corrected.
    ... are responsible) I could find via google was that people could "gang up" ... against a newbie. ... I think that's not a significant problem in practice. ... accounts I never heard of before. ...
    (rec.games.backgammon)
  • Re: Audit For Privileged Accounts
    ... Script which can scan domain member servers and enumerate ... accounts or domain groups which are the members of local Administrator group. ... Is there is a command-line or script available which can generate a report ... Do you mean you need a script to generate a report to enumerate accounts, ...
    (microsoft.public.windows.server.security)