Re: How can I obtain a report of users and roles in SQL Server?
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 10/19/05
- Next message: Sue Hoegemeier: "Re: Granting permissions to xp_regread"
- Previous message: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- In reply to: José Archondo: "How can I obtain a report of users and roles in SQL Server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 19 Oct 2005 14:15:49 -0400
You should also run sp_helplogins. That will help define where
sp_helprotect should be run.
RLF
"José Archondo" <jarchondo@spvs.gov.bo> wrote in message
news:uMv%23UlC1FHA.664@tk2msftngp13.phx.gbl...
>I need a query (script) or a tool to obtain a report (or audit report) for
> all databases instanced into SQL Server, just for an entittlement review
> aun
> audit reports.
>
> The fields are:
>
> User, role, permissions, last date access
>
> Best regards to everyone.
>
> José
>
>
- Next message: Sue Hoegemeier: "Re: Granting permissions to xp_regread"
- Previous message: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- In reply to: José Archondo: "How can I obtain a report of users and roles in SQL Server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
