Db owner list

Hi good day.
just a quick question. i cannot seem to find what I m
looking on the net so maybe some can help here.
I need to pull a report or just create a query for
this.
At a client site i have noticed that alot of people are
Db owners at specific servers.which could cause huge problem
for security purposes.
1. can someone help me with a procedure query that
will be able to check all servers in a specific
network where users are memebers of the Database owners
group. something like check all sql users(AD users and Sql
users) againts their user mapping and show if they belong to
the db_owners group.
2.. alternatively , iknow that this a big ask so maybe
if i could query each server individually..
to filter all users in a sql server that are in the Db
owners group. show only if they belong to the DB owners
group.
thanks
and hope that someone can help this google junkie..See if you can find it on http://www.sqlcommunity.com/ (under SQL Automation
section) If you can't then you can request one from "Tell us what you want"
section of the main page.
I think there's a script called SQL_ConfigSPY that can help you with what
you are looking for.
Thank you,
Saleem Hakani
WWW.SQLCOMMUNITY.COM
SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
SQL Server Radio, SQL Server Events..
"7736" wrote:
> Hi good day.
> just a quick question. i cannot seem to find what I m
> looking on the net so maybe some can help here.
> I need to pull a report or just create a query for
> this.
> At a client site i have noticed that alot of people are
> Db owners at specific servers.which could cause huge problem
> for security purposes.
> 1. can someone help me with a procedure query that
> will be able to check all servers in a specific
> network where users are memebers of the Database owners
> group. something like check all sql users(AD users and Sql
> users) againts their user mapping and show if they belong to
> the db_owners group.
> 2.. alternatively , iknow that this a big ask so maybe
> if i could query each server individually..
> to filter all users in a sql server that are in the Db
> owners group. show only if they belong to the DB owners
> group.
> thanks
> and hope that someone can help this google junkie..
>|||On Sep 29, 11:24 pm, Saleem Hakani
<SaleemHak...@.discussions.microsoft.com> wrote:
> See if you can find it onhttp://www.sqlcommunity.com/(under SQL Automation
> section) If you can't then you can request one from "Tell us what you want"
> section of the main page.
> I think there's a script called SQL_ConfigSPY that can help you with what
> you are looking for.
> Thank you,
> Saleem Hakani
> WWW.SQLCOMMUNITY.COM
> SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
> SQL Server Radio, SQL Server Events..
>
> "7736" wrote:
> > Hi good day.
> > just a quick question. i cannot seem to find what I m
> > looking on the net so maybe some can help here.
> > I need to pull a report or just create a query for
> > this.
> > At a client site i have noticed that alot of people are
> > Db owners at specific servers.which could cause huge problem
> > for security purposes.
> > 1. can someone help me with a procedure query that
> > will be able to check all servers in a specific
> > network where users are memebers of the Database owners
> > group. something like check all sql users(AD users and Sql
> > users) againts their user mapping and show if they belong to
> > the db_owners group.
> > 2.. alternatively , iknow that this a big ask so maybe
> > if i could query each server individually..
> > to filter all users in a sql server that are in the Db
> > owners group. show only if they belong to the DB owners
> > group.
> > thanks
> > and hope that someone can help this google junkie..- Hide quoted text -
> - Show quoted text -
HI there.
i tried looking in there.. even send a request but no
one has replied as yet.. I will keep o trying anyways.
Thanks for the link though.. Learnt more already.. from
that site..