Hi,
This is kiran from India. I would like to ask one question regarding the
MS-SQL 2000
"db_owner" access permission user.
On one server we have 50 databases and indivual database have there own
db_owner access assigned to WINODWS 2000 DOMAIN LOCAL USERS and Local users
and Global users .
My question is how to retirve the list of users who are members of DB_OWNERS
and WINODWS 2000 DOMAIN LOCAL USERS and Local users and Global users using
SQL script or by any other means other than going to each database and check
the users in DB_OWNERS.
Please help me ....
Kiran S
Hi
sp_helplogins
"KIRAN MAHA PATRO.S" <KIRANMAHAPATROS@.discussions.microsoft.com> wrote in
message news:C9BCE7B7-BE41-4A88-87D9-F483F6929201@.microsoft.com...
> Hi,
> This is kiran from India. I would like to ask one question regarding the
> MS-SQL 2000
> "db_owner" access permission user.
> On one server we have 50 databases and indivual database have there own
> db_owner access assigned to WINODWS 2000 DOMAIN LOCAL USERS and Local
users
> and Global users .
> My question is how to retirve the list of users who are members of
DB_OWNERS
> and WINODWS 2000 DOMAIN LOCAL USERS and Local users and Global users using
> SQL script or by any other means other than going to each database and
check
> the users in DB_OWNERS.
> Please help me ....
> Kiran S
>
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment