Changing DBO

From: JLFleming (anonymous_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 09:47:22 -0700

I have assigned an SQL account as DBO of a database. I
am going to change the DBO to a Windows login account.
When I run the sp_changedbowner stored procedure, will
change the owner of the objects created by the SQL
account? The table objects have the SQL account as the
owner. If not, will I have to run the
sp_changeobjectowner too?

Thank you,
JLFleming

Relevant Pages

  • Re: Database roles
    ... > This stored procedure does a bulk insert into CUSTODIAN_HOLDINGS_IMPORT ... >> You mention a dbo table but the error suggests it is not dbo. ... >> Andrew J. Kelly SQL MVP ... >>> In SQL 2000 if a sql account has bulkadmin, ...
    (microsoft.public.sqlserver.security)
  • Re: Database roles
    ... The code looks something like this - (if I give the sql account db_ddladmin ... then this executes without errors) ... This stored procedure does a bulk insert into CUSTODIAN_HOLDINGS_IMPORT ... > You mention a dbo table but the error suggests it is not dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Database roles
    ... You mention a dbo table but the error suggests it is not dbo. ... can you post the actual code you are trying to execute? ... "Meenal Dhody" wrote in message ... > I wanted to avoid giving the sql account dbo privileges. ...
    (microsoft.public.sqlserver.security)
  • Database roles
    ... In SQL 2000 if a sql account has bulkadmin, datareader and datawriter it ... that enough to use bulk insert to a dbo table? ... I wanted to avoid giving the sql account dbo privileges. ...
    (microsoft.public.sqlserver.security)
  • Changing DBO
    ... >I have assigned an SQL account as DBO of a database. ... >am going to change the DBO to a Windows login account. ... >change the owner of the objects created by the SQL ...
    (microsoft.public.sqlserver.security)