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

From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 03/03/03 

From: "Tom Moreau" <tom@dont.spam.me.cips.ca>
Date: Mon, 3 Mar 2003 14:59:55 -0500

Maybe it's because I'm older... ;-) 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada   tom@cips.ca
www.pinnaclepublishing.com/sql
  "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message news:#39MV7b4CHA.2428@TK2MSFTNGP09.phx.gbl...
  Do what Tom says :-)
  Same caveat applies as to owner qualifying the objects.
  I had always been under the impression you had to be
  a member of db_owner to create objects as dbo, you
  learn something new everyday :-)
  -- 
  HTH
  Jasper Smith (SQL Server MVP)
  I support PASS - the definitive, global
  community for SQL Server professionals -
  http://www.sqlpass.org
  "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
  news:#h6s72b4CHA.1900@TK2MSFTNGP10.phx.gbl...
  > 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