How can I obtain a report of users and roles in SQL Server?
From: José Archondo (jarchondo_at_spvs.gov.bo)
Date: 10/18/05
- Next message: Rob R. Ainscough: "Re: sa loginname being hacked"
- Previous message: Joseph Bittman MVP MCSD: "Re: sa loginname being hacked"
- Next in thread: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- Reply: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- Reply: Russell Fields: "Re: How can I obtain a report of users and roles in SQL Server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 18 Oct 2005 17:17:23 -0400
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: Rob R. Ainscough: "Re: sa loginname being hacked"
- Previous message: Joseph Bittman MVP MCSD: "Re: sa loginname being hacked"
- Next in thread: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- Reply: Hari Prasad: "Re: How can I obtain a report of users and roles in SQL Server?"
- Reply: Russell Fields: "Re: How can I obtain a report of users and roles in SQL Server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]