How can I obtain a report of users and roles in SQL Server?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

José Archondo - 18 Oct 2005 22:17 GMT

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é

Reply to this Message

Hari Prasad - 19 Oct 2005 08:33 GMT

See:-

SYSPROTECT system table and system procedure SP_HELPROTECT

Thanks
Hari
SQL Server MVP

>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
[quoted text clipped - 8 lines]
>
> José

Reply to this Message

Russell Fields - 19 Oct 2005 19:15 GMT

You should also run sp_helplogins. That will help define where
sp_helprotect should be run.

RLF

>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
[quoted text clipped - 8 lines]
>
> José

Reply to this Message