Login and corresponding user rights

Hello,

I want to retrieve information for a SQL or NT login that has different
types of privileges in all the DB's. Lets say NT login Domain\Test has acces
s
to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
db_datareader and db_datawriter to Northwind, public to HR and Finance. So I
just need the full summary with one script.

I can look this info by clicking the login in security folder in enterprise
manager. But I have over 200 databases in many different servers and it take
s
huge time.

I really appreciate it in advance.

David,

Did you try with sp_helpuser?


AMB

"David" wrote:

> Hello,
>
> I want to retrieve information for a SQL or NT login that has different
> types of privileges in all the DB's. Lets say NT login Domain\Test has acc
ess
> to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
> db_datareader and db_datawriter to Northwind, public to HR and Finance. So
 I
> just need the full summary with one script.
>
> I can look this info by clicking the login in security folder in enterpris
e
> manager. But I have over 200 databases in many different servers and it ta
kes
> huge time.
>
> I really appreciate it in advance.