Ravikanth's Blog

Happenings around Me

Disclaimer

India MVP Blogs

Mugh blogs

My

My Favorites

My Network Places

How to determine who has sa or dbo privileges in SQL Server

Login to SQL Server using Query analyzer and execute following commands under “master” database

 

sp_helpsrvrolemember 'SYSADMIN'

 

Who ever comes under this result set will be able to do all the activities inside that sql server instance.

 

 

For Database level dbo previlages, execute

 

sp_helprolemember 'db_owner'

Posted: Aug 16 2006, 11:29 AM by dvravikanth | with 10 comment(s)
Filed under:

Comments

How to determine who has sa or dbo privileges in SQL Server said:

Pingback from  How to determine who has sa or dbo privileges in SQL Server

# November 26, 2007 4:32 AM

domanjkox said:

nore igrace <a href=www.vsezasport.si/.../tekalne-steze>Tekalne steze</a> za sprostitev.

# November 19, 2011 12:04 AM

aben said:

nore igrace <a href=www.vsezasport.si/.../a> za sprostitev.

# November 19, 2011 12:04 AM

marijax said:

nore igrace <a href=www.vsezasport.si/.../otroski-tricikli>Otroski tricikli</a> za sprostitev.

# November 19, 2011 3:18 AM

belajc said:

nore igrace <a href=www.vsezasport.si/.../fitnes-naprave>Fitnes naprave</a> za sprostitev.

# November 19, 2011 3:18 AM

cafutaf said:

nore igrace <a href=www.vsezasport.si/.../suunto>Suunto ure</a> za sprostitev.

# November 21, 2011 9:40 AM

bobicc said:

nore igrace <a href=www.vsezasport.si/.../fitnes-oprema>Fitnes oprema</a> za sprostitev.

# November 21, 2011 11:31 AM

kolenkop said:

nore igrace <a href=www.vsezasport.si/.../a> za sprostitev.

# November 21, 2011 12:02 PM

horvato said:

nore igrace <a href=www.drustvo-nasi.si/>Otroska igrala za prireditve</a> za sprostitev.

# November 21, 2011 12:28 PM

cestnike said:

nore igrace <a href=www.vsezasport.si/.../otroski-peskovniki>Otroski peskovniki</a> za sprostitev.

# November 21, 2011 12:45 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)