how to find out who has db_owner rights through all the logins   

Hi,

I found some of the users who has db_owner right, I'm afraid that more 
people have it. Is there a way to find them using a script?

Thanks a lot,
Sarah

date: Mon, 21 Jul 2008 09:02:09 -0700   author:   sg

Re: how to find out who has db_owner rights through all the logins   

sg,

In a single database, to show the members of the db_owner role:

sp_helpuser db_owner

RLF

"sg"  wrote in message 
news:D4AF6802-F1F0-4F26-A62C-1D6955A9BC59@microsoft.com...
> Hi,
>
> I found some of the users who has db_owner right, I'm afraid that more
> people have it. Is there a way to find them using a script?
>
> Thanks a lot,
> Sarah

date: Tue, 22 Jul 2008 00:10:19 -0400   author:   Russell Fields

Re: how to find out who has db_owner rights through all the logins   

Thanks very much Russell, it is very helpful and simple.

"Russell Fields" wrote:

> sg,
> 
> In a single database, to show the members of the db_owner role:
> 
> sp_helpuser db_owner
> 
> RLF
> 
> "sg"  wrote in message 
> news:D4AF6802-F1F0-4F26-A62C-1D6955A9BC59@microsoft.com...
> > Hi,
> >
> > I found some of the users who has db_owner right, I'm afraid that more
> > people have it. Is there a way to find them using a script?
> >
> > Thanks a lot,
> > Sarah 
> 
> 
>

date: Tue, 22 Jul 2008 06:55:00 -0700   author:   sg