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

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.
JosSee:-
SYSPROTECT system table and system procedure SP_HELPROTECT
Thanks
Hari
SQL Server MVP
"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
>|||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
>

How can I hide leaf level members of a ragged dimension ?

I need to hide leaf level members of a ragged dimension. Any thoughts ? My original approach was through roles (security), but I am open to other suggestions.

Maybe I need to generalize this. Is it possible to hide lower levels of a heirarchical dimension ?

Specifically, I have our corporate organization, with the following heirarchy:

CEO-->ExecVP-->VP-->Director-->Manager-->Supervisor-->Employee.

I need to be able to hide measures associated with leaf-level employees, and also selectively at the small group (supervisor) level. But security seems to work backwards--I can hide top level aggregations, but not the lower level.

Any ideas ?

How can I hide leaf level members of a ragged dimension ?

I need to hide leaf level members of a ragged dimension. Any thoughts ? My original approach was through roles (security), but I am open to other suggestions.

Maybe I need to generalize this. Is it possible to hide lower levels of a heirarchical dimension ?

Specifically, I have our corporate organization, with the following heirarchy:

CEO-->ExecVP-->VP-->Director-->Manager-->Supervisor-->Employee.

I need to be able to hide measures associated with leaf-level employees, and also selectively at the small group (supervisor) level. But security seems to work backwards--I can hide top level aggregations, but not the lower level.

Any ideas ?