Problem creating objects not as dbo

[Philip]

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.

[Dan Guzman]

If you want users to create only objects owned by their own userid,
grant them CREATE statement privileges and remove them from the db_owner
and db_ddladmin fixed database roles as well as the sysadmin server
role.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

[url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
[url]http://www.sqlserverfaq.com[/url]
[url]http://www.mssqlserver.com/faq[/url]
-----------------------

"Philip" <atec396@hotmail.com> wrote in message
news:013e01c347c9$76c75780$a301280a@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.
>