Database roles

From: Meenal Dhody (meenal_dhody_at_hotmail.com)
Date: 09/16/05 

Date: Thu, 15 Sep 2005 23:49:29 -0400

Hi,

In SQL 2000 if a sql account has bulkadmin, datareader and datawriter it
that enough to use bulk insert to a dbo table? I am getting the following
error with the current permissions:

Currently user is not the owner of GDS.HOLDINGS_IMPORT. Cannot perform SET
operation.

I wanted to avoid giving the sql account dbo privileges.

thanks
Meenal

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)
  • 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)
  • 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)