|
Home > Archive > MS SQL Server > April 2006 > Login and corresponding user rights
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.
| |
| Alejandro Mesa 2006-04-06, 8:23 pm |
| 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.
|
|
|
|
|