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:54:04 -0000

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

  • Re: problem with cast and unions
    ... The part where there is that problem is about conversion from a C float ... to a Small "cell" (actually an int). ... structure, and even then, only if it was NOT the member most recently ... need to declare the union. ...
    (comp.lang.c)
  • Re: When creating a new table, owner is DBO I need another user
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Default User
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Read-only, as opposed to const member
    ... >> Don't change it from int to double. ... Every Cheese object needs to have a member function which returns ... No more, no less, just a read-only member variable. ...
    (comp.lang.cpp)
  • Re: C++ in ternms of C
    ... >A class has its member variables, ... > int b, c, d; ... >the compiler performs these checks to tell us that our code conforms to the ... >design specification of the class (for example, not changing the member ...
    (microsoft.public.vc.language)