dbo/owner

Can anyone think of a way to make this work...
We are restructuring our IT organization such that we will have schema
owners (can change tables and structure in a database) and t-sql/proc
writers (can only create procs and set permissions on those procs). However,
we want to use dbo as the owner of the procs (without assigning the
t-sql/proc writers to the db_owner role).The only way the users can create procedures with dbo as the owner is to be
a member of the db_owner role (or sysadmin).
However, you can use the sp_changeobjectowner procedure to change the owner
of the procedures after they are created. This will require a little more
administrative effort.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||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 abl
e to execute the proc, just create it.
create procedure dbo.sptest
as
select * from authors
go