Re: Is this really the best way?

From: David Pendleton (qnircra@gpd.arg)
Date: 01/23/03 

From: "David Pendleton" <qnircra@gpd.arg>
Date: Thu, 23 Jan 2003 07:29:27 -0600

Sure they could, if they were the dbo. Hence, my question:

> Can the db_developer role be granted the ability to create procedures as
dbo?

Thanks anyway. 

--
ROT13 my email address to reply: qnircra@gpd.arg
"Moff" <moffnospam@hotmail.com> wrote in message
news:#hv#mwrwCHA.2124@TK2MSFTNGP11...
> They could just write CREATE PROCEDURE dbo.MyProc AS ....
>
>
> "David Pendleton" <qnircra@gpd.arg> wrote in message
> news:O6gmi$kwCHA.2504@TK2MSFTNGP10...
> > Our SQL developers authenticate via Windows NT.
> >
> > Each developer is a member of a database role, db_developer. This role
has
> > been granted CREATE PROCEDURE and FUNCTION and is also a member of
> > db_datareader and db_datawriter.
> >
> > During development, a developer creates an object, in their own schema,
> > resulting in something like:
> >
> > dave.sp_my_procedure
> >
> > Other developers working in other languages, ASP for example, must
qualify
> > their stored procedure calls with the same schema.
> >
> > When the code is migrated to a QA environment, a DBA must change object
> > ownership to dbo, and the ASP developers must modify their code once
again
> > to work with the new schema.
> >
> > This is tedious, time consuming and is prone to error. Is there a better
> > way? Can the db_developer role be granted the ability to create
procedures
> > as dbo?
> >
> > Thanks all.
> >
> > --
> > ROT13 my email address to reply
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: User table updates are recorded as dbo instead of userid
    ... developers will be identified as dbo in every database. ... Remove the developers from the local computer Administrators group, ... Developers having sysadmin permissions? ... 2) sysadmin role members and 3) dbo aliases. ...
    (microsoft.public.sqlserver.security)
  • Re: User table updates are recorded as dbo instead of userid
    ... all Developers are also ... up as dbo when updating tables? ... 2) sysadmin role members and 3) dbo aliases. ...
    (microsoft.public.sqlserver.security)
  • Re: User table updates are recorded as dbo instead of userid
    ... If all developers are members of BUILTIN\Administrators, and BUILTIN\Administrators is a member of the sysadmin group, then all developers will be identified as dbo in every database. ... Developers having sysadmin permissions? ...
    (microsoft.public.sqlserver.security)
  • Re: deny truncate?
    ... > They do not need to be dbo to execute a dbo owned stored procedure. ... > GRANT EXECUTE ON dbo.YourProcName TO DeveloperNameGoesHere ... amount of developers, only 5 - in fact there's twice as many servers than ...
    (microsoft.public.sqlserver.security)
  • Re: Not using SA - Then what?
    ... >> You can add developers to the db_owner role and use Windows ... >> Any objects they create will be owned by dbo. ... >>> do I have multiple developers/managers login to enterprise manager ... >> A much better approach is to have developers write scripts to create all ...
    (microsoft.public.sqlserver.security)