Permission to create/alter proc but not the dbowner

Question

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

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

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 1

You can use ddl_admin. But, you may also have to give them security_admin in order to set permissions on the procedures they create.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

SQL_Surfer SSCrazy Eights Points: 8320 More actions · Answer 2

Thank Grant for the prompt response. I would also avoid them to drop tables. Is it possible?

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

Then you can individually go through and REVOKE privileges too.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt