302621 BulkAdmin permission

From: Gary Billins (gbillins_at_petvalu.com)
Date: 07/30/04

  • Next message: Monty: "Best Security Template for a Member Server level SQL server install" 
    Date: Fri, 30 Jul 2004 06:37:09 -0700

    What is the status of this SQL Server 2000 problem?
    I cannot find any fix for this problem.

    SYMPTOMS
    If a BULK INSERT command is issued by a user who
    Is part of the bulkadmin server role and has INSERT
    permissions to the table
    Is not part of the sysadmin, db_ddladmin, or db_owner role
    Is not the database owner
    The following error message is generated:

    Server: Msg 8104, Level 16, State 2, Line 1
    The current user is not the database or object owner of
    table '<table_name>'. Cannot perform SET operation.
    WORKAROUND
    To work around the problem, make sure that the user is
    also part of either the db_ddladmin or the db_owner
    database role in addition to the bulkadmin server role.
    Another workaround is to make the user the owner of the
    database.

    Thanks

  • Next message: Monty: "Best Security Template for a Member Server level SQL server install"

    Relevant Pages

    • Re: SQL 2005 Express-Database does not have a valid owner?
      ... That means that the database's owner is MYDOMAIN\MyUserName ... My design machine is running Windows XP Pro. ... database diagram. ... Database diagram support objects cannot be installed because this ...
      (microsoft.public.sqlserver.security)
    • Re: conflicting object names in sql server 2000
      ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
      (microsoft.public.sqlserver.server)
    • Re: unknown database owner
      ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
      (microsoft.public.access.security)
    • Re: Cross database update issue
      ... Also, for dbo-owned objects, the owner of both databases must be the ... You can execute sp_helpdb to determine the current database owners. ... > User Name: Test1 Role Name=Test ... > Role Test has select permission to table t_test ...
      (microsoft.public.sqlserver.security)
    • Re: Cant access any old tables
      ... I used the same access rights to test the table in the different database. ... Is there a place to set a TABLE owner separate from the database owner? ... but one was SQL based and the other Windows Secured. ...
      (microsoft.public.sqlserver.security)