Re: Database roles

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/16/05

  • Next message: Meenal Dhody: "Re: Database roles" 
    Date: Fri, 16 Sep 2005 10:01:57 -0400

    You mention a dbo table but the error suggests it is not dbo. In any event
    can you post the actual code you are trying to execute? 

    -- 
Andrew J. Kelly  SQL MVP
"Meenal Dhody" <meenal_dhody@hotmail.com> wrote in message 
news:u7laRHnuFHA.3256@TK2MSFTNGP09.phx.gbl...
> 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
>
>
  • Next message: Meenal Dhody: "Re: Database roles"

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