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 access
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 takes
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 access
> 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 takes
> huge time.
> I really appreciate it in advance.

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.

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 access
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 takes
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 access
> 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 takes
> huge time.
> I really appreciate it in advance.