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.

Login

Is it poosible to create a user in SQL Server 2000 who has the rights to
update, delete & insert in a database. The user can login in to tha databas
e
through a third party application i.e VB etc but cannot log directly on the
enterprise manager and query analyzer console.
ThankxYes,
S2K Database has Role and User.
You can create users and roles.
You can use built-in Database Role such as db_datawriter.
"Muhammad Bilal"?? ??? ??:

> Is it poosible to create a user in SQL Server 2000 who has the rights to
> update, delete & insert in a database. The user can login in to tha datab
ase
> through a third party application i.e VB etc but cannot log directly on th
e
> enterprise manager and query analyzer console.
> Thankx