db_owner script

Question

db_owner script

krypto69

SSChampion

Points: 13604
More actions
September 22, 2009 at 7:03 am

#214682

Can someone with db_owner rights (only) script out a stored procedure?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

Yes on that database only, although you can look at stored procedure with lower rights, if they can run select statements against the syscomments table.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Lowell SSC Guru Points: 323518 More actions · Answer 2

yes.

as db_owner, you own every object in the database; you can read/write, as well as create/alter/drop all the objects...

db_owner is a powerful role so it's like having db_datareader,db_datawriter and ddl_admin, but with even more rights than those roles would give.

did you think it was a minor role that just tagged a user to the database?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

krypto69 SSChampion Points: 13604 More actions · Answer 3

No, the user was complaining that they could not script...I told them they had the rights to...

Thanks guys..