Re: db_ddladmin database role and dbo security
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 12/02/02
- Next message: Rob: "Login properties..."
- Previous message: Sue Hoegemeier: "Re: How can i connect Exchange server using by linked server"
- In reply to: juanita: "db_ddladmin database role and dbo security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Mon, 02 Dec 2002 07:19:28 -0700
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"
<jdrobish@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.
- Next message: Rob: "Login properties..."
- Previous message: Sue Hoegemeier: "Re: How can i connect Exchange server using by linked server"
- In reply to: juanita: "db_ddladmin database role and dbo security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
