db_ddladmin database role and dbo security

[Sue Hoegemeier]

It depends on what you need for security in the development
environment. db_securityadmin would allow the developer to
grant permissions or the developer could be granted
db_owner. Or if you or the DBA can execute the create
procedure statement and grant the developer execute rights.

-Sue

On Tue, 19 Nov 2002 08:35:56 -0800, "juanita"
<jdro...@lafayettegov.com> wrote:

>HI. I have a developer that I gave db_ddladmin role so he
>can create objects by specifying DBO as the owner. But
>after he was able to create the object he could not
>execute the stored proc because he didn't have permission
>to execute it. I understand that if he would have created
>the object with himself as the owner, permission is
>automatically granted, but I would have thought that since
>he can specify DBO,permission would work the same. Would I
>just have to give him the db_securityadmin so he can grant
>his ownself security or is there a better way to
>accomplish this. This is all done in a development
>envirnonment.