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

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / General / Security / July 2008

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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 21 Jul 2008 17:02 GMT

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

Reply to this Message

Russell Fields - 22 Jul 2008 05:10 GMT

sg,

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

sp_helpuser db_owner

RLF

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks a lot,
> Sarah

Reply to this Message

sg - 22 Jul 2008 14:55 GMT

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

> sg,
>
[quoted text clipped - 11 lines]
> > Thanks a lot,
> > Sarah

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.