Thursday, March 22, 2012

302621 BulkAdmin permission

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.
ThanksIf your environment doesn't permit you to implement the workarounds
suggested in the article, consider using another technique such as DTS or
BCP.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Billins" <gbillins@.petvalu.com> wrote in message
news:727a01c4763a$502d66f0$a401280a@.phx.gbl...
> 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

No comments:

Post a Comment