Re: creating objects with dbo creator without being a sys admin

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 03/03/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Mon, 3 Mar 2003 19:46:12 -0000

Make them a member of the db_owner fixed database role
They will need to specify dbo as the object owner otherwise
it will default to their username e.g.

If user bob is a non sysadmin and member of db_owner role

create table dbo.blah(col1 int)

will create table dbo.blah whereas

create table blah(col1 int)

will create table bob.blah 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Megan" <Tracy_Megan_M@cat.com> wrote in message
news:053801c2e1bb$b89e47f0$3001280a@phx.gbl...
> How can I have my customers create tables/views with a dbo
> creator without giving them system admin rights?

Relevant Pages

  • RE: Ready only Account?
    ... You could grant the users in the database db_datareader role. ... Adding a Member to a Predefined Role in Books Online. ... Windows NT 4.0 or Windows 2000 user or group, or a SQL Server user or role) ... as a member of a fixed database role. ...
    (microsoft.public.sqlserver.security)
  • Permission problem on sp_adjustpublisheridentityrange
    ... "Only members of the sysadmin fixed server role or db_owner ... fixed database role can execute sp_adjustpublisheridentityrange". ... If you run this stored procedure as a user that is member of db_owner role ...
    (microsoft.public.sqlserver.replication)