Database Ownership 7.0

[mike...@my-deja.com]

We are currently migrating to SQL 7.0 from 6.5. In
6.5 we kept database ownership as dbo(sa). When a
DB is created or restored, the owner was defaulted to
the dbo(sa).

We have noticed that when someone signed in, using integrated
security and has system administrator role, creates or restores
a database, the database owner becomes that user's login.

Our theory is that this is not an issue, but we need some
confirmation on this.

We would like to know how other's are using the dbowner role.

Any help is greatly appreciated.
Thanks in advance

Mike Helm
Database Administrator
Principal Financial Group
mike...@my-deja.com

Sent via Deja.com http://www.deja.com/
Before you buy.

[BPMargolin]

Mike,

In SQL Server 7.0, like in SQL Server 6.5 it is an excellent policy to have
all database objects owned by dbo.

In SQL Server 7.0, when creating a database object, create it explicitly as
owned by dbo, for example:

create table dbo.<tablename>
create procedure dbo.<procname>

<mike...@my-deja.com> wrote in message news:80v7qn$gar$1...@nnrp1.deja.com...