db_ddladmin database role and dbo security

From: juanita (jdrobish@lafayettegov.com)
Date: 11/19/02 

From: "juanita" <jdrobish@lafayettegov.com>
Date: Tue, 19 Nov 2002 08:35:56 -0800

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.

Relevant Pages

  • Re: database split before or after security?
    ... I always have a user as owner, ... Developer Group, both groups have identical security permissions. ... forms) but not the tables or queries. ... Group nor the Developer Group has Open/Run permissions on the tables ...
    (microsoft.public.access.security)
  • Re: [kde] Associaton configuration in Konqueror
    ... and if there is that its owner is also your user and it is at least "rw" ... "touch" means it will only modify the access timestamp, ... Kevin Krammer, KDE developer, xdg-utils developer ...
    (KDE)
  • User rights problem
    ... "Specified owner name 'dbo' either does not exist or you do not have ... rights which i should give to the "developer" login for donig so. ...
    (microsoft.public.sqlserver.security)
Quantcast