DBO Best Practices

From: Tim Ford (tford@in2focus.com)
Date: 10/23/02

Next message: Tom Moreau: "Re: DBO Best Practices"
Previous message: Hari: "Re: SQL 2000 and NTFS"
Next in thread: Tom Moreau: "Re: DBO Best Practices"
Reply: Tom Moreau: "Re: DBO Best Practices"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: "Tim Ford" <tford@in2focus.com>
Date: Wed, 23 Oct 2002 12:58:53 +0100

Could some please tell we the best practices for the dbo user. Currently I
have it set to my domain account DOMAIN_NAME\Timf, Should the dbo of
database be the same as the NT Account running the SQL Services??

Thanks Tim

Next message: Tom Moreau: "Re: DBO Best Practices"
Previous message: Hari: "Re: SQL 2000 and NTFS"
Next in thread: Tom Moreau: "Re: DBO Best Practices"
Reply: Tom Moreau: "Re: DBO Best Practices"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Orphaned user owns objects as dbo and cannot be dropped.
... So I had to directly update the dbo.sysobjects system table to chane the uid ... How can I get rid of this use name in this database? ... SQL server to the production server. ... the database dbo user is ...
(microsoft.public.sqlserver.security)
Re: Orphaned user owns objects as dbo and cannot be dropped.
... SQL Server MVP ... "Dan Guzman" wrote: ... How can I get rid of this use name in this database? ... the database dbo user is ...
(microsoft.public.sqlserver.security)
Re: Snapshot Agent account rights
... I select Login Properties for a domain account and select User Mapping. ... User, group, or role 'dbo' already exists in the current database. ...
(microsoft.public.sqlserver.replication)
Re: Orphaned user owns objects as dbo and cannot be dropped.
... How can I get rid of this use name in this database? ... I suspect this is a different problem than the database owner. ... SQL server to the production server. ... the database dbo user is ...
(microsoft.public.sqlserver.security)
SQL Server 2005 Acting Up (not a valid dbo).
... This database does not have a valid dbo user or you do not have ... permissions to impersonate the dbo user, ...
(microsoft.public.dotnet.faqs)