Re: how to find out who has db_owner rights through all the logins
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Tue, 22 Jul 2008 00:10:19 -0400
sg,
In a single database, to show the members of the db_owner role:
sp_helpuser db_owner
RLF
"sg" <sg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D4AF6802-F1F0-4F26-A62C-1D6955A9BC59@xxxxxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Rename AD group
- Next by Date: Re: Using trusted database connection across domains
- Previous by thread: how to find out who has db_owner rights through all the logins
- Next by thread: Question: How to secure SQL ERP Dtabase on Network
- Index(es):
Relevant Pages
|
