Re: Object Created under DBO to different owner name

From: Phil (atec396_at_hotmail.com)
Date: 07/11/03 

Date: Fri, 11 Jul 2003 13:23:43 -0700

Yes it would be easier to have the owner dbo. I don't
have that option of choosing.
My users want the owner to be thier login
account, NEVER dbo. Sometimes when they
create objects its under thier login sometimes
it is under dbo. They hate typing xxx.tablename
to create objects. How do I stop dbo from owning
anything and have SQL Server use thier login account.

>-----Original Message-----
>Personally I like everything being owned by dbo, makes
life much simpler in
>the long run. But anyway you can specify the owner when
you create the
>object and it will create it as such. If you don't
specify then it has to
>decide on it's own.
>
>CREATE TABLE [John].[HisTable] (....
>
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"Philip" <atec396@hotmail.com> wrote in message
>news:01e101c347c9$29c598c0$a101280a@phx.gbl...
>> I have a problem with people logging on
>> as one user, but sql server keeps
>> changing the owner to dbo. Sometimes
>> the owner name will be their loggin
>> account and sometimes it will be dbo.
>> Is there anyway to stop dbo from
>> becoming the owner, it is really
>> fouling things up.
>>
>> There are only two users in the database,
>> so how do I keep dbo from owning anything.
>> I never want anybody creating object as dbo.table.
>>
>
>
>.
>

Relevant Pages

  • Table record editing permissions
    ... The 'dbo' account means that 'sa' is the owner. ... without being granted permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Object Created under DBO to different owner name
    ... >> Yes it would be easier to have the owner dbo. ... >> create objects its under thier login sometimes ... They hate typing xxx.tablename ...
    (microsoft.public.sqlserver.security)
  • All tables are invalid objects
    ... tables still exist and find out who the owner is by ... dbo with the table owner if not dbo) ... My guess is that somehow the account your using to connect ... >Server Config, Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)