Re: bo-bo question

From: Allan Mitchell (allan@no-spam.sqldts.com)
Date: 03/12/03

  • Next message: Peter Bij: "Re: Change max-number logins to zero" 
    From: "Allan Mitchell" <allan@no-spam.sqldts.com>
Date: Wed, 12 Mar 2003 08:21:09 -0000

    Hello, rick!

    You will as you have rightly stated need to change the owner of any
    databases the login owns. Also if the login owns jobs you will asked to
    reassign them.

    You should try to have all objects owned by dbo as it helps things like
    "Ownership chains" and administration 

    --
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Mucho thanks,
      ---  Microsoft CDO for Windows 2000
  • Next message: Peter Bij: "Re: Change max-number logins to zero"

    Relevant Pages

    • Re: Security, Views, Multiple DBs
      ... the 'top' object is also mapped to the user that is the owner of the 'lower ... the same login, It's enough just to give your users permissions on the 'top' ... "Security Considerations for Cross-Database Ownership Chaining: ... highly-privileged users with data in other databases. ...
      (microsoft.public.sqlserver.security)
    • Re: Triggers
      ... Check the owner reported in the sp_helpdb output to ensure the databases ... EXEC sp_helpdb 'RegionalOffice' ... sp_changedbowner so that they are owned by a common login. ...
      (microsoft.public.sqlserver.security)
    • Database Security
      ... >>2000 server as the OS with SQL server 2000 Enterprise ... >>I have 12 databases that require a lot of manual ... >>intervention when it comes to jobs. ... >>from 30 legacy systems) These often fail and the owner ...
      (microsoft.public.sqlserver.security)
    • who is the owner..
      ... 1> if using SQL Authentication then instead of using the sa login to access the instance, we should create a new login (and it's new mapped user)and use it for our applications' interaction with the db. ... 2> that the dbo should remain the owner of the databases and also ... 3> that the owner of the database is the user who created it. ...
      (microsoft.public.sqlserver.msde)
    • Re: Error 21776 - dbo account
      ... Maybe some of the other databases where you didn't change ... the owner are mapped to a login that does not exist on the ... change the owner to sa. ...
      (microsoft.public.sqlserver.security)