Changing DBO

From: Volt (anonymous_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 07:29:13 -0700

Have you sorted it as yet

>-----Original Message-----
>
>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)