Re: dbo.objectname instead of username.objectname

From: Trayce Jordan (trayce@jordanhome.net)
Date: 05/23/02


From: "Trayce Jordan" <trayce@jordanhome.net>
Date: Wed, 22 May 2002 18:10:48 -0500


Have the database owner change the object ownership. I would avoid if
possible (especially if a production machine) giving developers dbo access.
If you ever have to tighten things down later - it will be a pain. Have the
environment tight from the beginning - and loosen as necessary.

Trayce Jordan MCDBA, MCSD

"Ken" <ken88@hotmail.com> wrote in message
news:5fc301c20148$780ff520$3bef2ecf@TKMSFTNGXA10...
> Hi All
> Does anyone know how to set SQL Server 7 to always give
> dbo instead of the name of the creator of the object?
>
> eg: If let's say user John want to create a table called
> ABC, the owner of the object will be John.ABC. Is there
> anyway to set it as dbo.ABC?
>
> Thanks
> Ken