Re: DBO Best Practices

From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 10/23/02 

From: "Tom Moreau" <tom@dont.spam.me.cips.ca>
Date: Wed, 23 Oct 2002 09:28:11 -0400

Typically, databases are owned by the sa account. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
  "Tim Ford" <tford@in2focus.com> wrote in message news:#c$zhtoeCHA.508@tkmsftngp12...
  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

Relevant Pages

  • Re: Joining tables from two databases
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... account with rights to both tables. ... to create a connection I need to use a connection ... Are these 2 databases are SQL Server? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Databases connections not working more with all web sites
    ... First check for permission problems. ... account for one of the sites with a problem to an account with administrator ... > Databases connections, both, for MS SQL Server 2000 and MS Access ...
    (microsoft.public.inetserver.asp.db)
  • Re: Joining tables from two databases
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm not really following how you are solving it using a service account. ... Are these 2 databases are SQL Server? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: public role???
    ... The guest user account cannot be removed from ... > databases, but not ... then that's the way SQL Server ...
    (microsoft.public.sqlserver.security)
  • Deny access to all users (including Administrator and DomainAdmins) except SA?
    ... How can I ensure that databases in a SQL Server instance are accessible (and ... manageable) ONLY through SA account or other accounts created by SA. ... Administrator or DomainAdmins of the box must be denied access to the DB. ... We ship SQL Server DB along with our product. ...
    (microsoft.public.sqlserver.security)