RE: dbo/owner

From: Randy Dyess (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 20:16:07 -0700

Michelle,

Have you tried making the t-sql/proc writers members of the db_ddladmin role and having them create the proc with dbo as the owner. They will not be able to execute the proc, just create it.

create procedure dbo.sptest
as
select * from authors
go

Relevant Pages

  • Re: Tables created by user
    ... owner name, or you can take ownership of the object using ... CREATE PROC dbo.sprTest1 ... EXEC sp_changeobjectowner 'someowner.Test1', 'dbo' ...
    (microsoft.public.sqlserver.security)
  • Finding a creator of object
    ... whenever dbo is prifixed with the create script the owner becomes dbo. ... create proc dbo.test ...
    (comp.databases.ms-sqlserver)
  • Re: TableAdapter to create new SQL stored proc with different owne
    ... I actually believe it the wizard either needs a way to set a database owner ... or go ahead and allow a stored proc to be created with current credentials. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Owner Qualified procedures and compiles
    ... So it's worth doing but probably only when you are editing a proc for other ... > referenced by owner to reduce not necessarily recompiles but rather ... >> create all procedures with a qualified owner name. ... >> should qualify the owner on the exec call. ...
    (microsoft.public.sqlserver.programming)
  • Re: Unable to Drop / Alter a Proc that Exists
    ... It's recommended best practice to always include the object owner name when working with objects, even if the owner is dbo. ... we cannot ALTER / DROP the proc either because we get an error message that says it does not exist in the system catalog. ...
    (microsoft.public.sqlserver.server)