English

Error: SqL0551N "'WORLD' does not have the privilege to perform operation "GRANT"

Error Message

A data loading operation fails with the error:

"Underlying DBMS error[IBM][CLI]SqL0551N "WORLD' does not have the privilege to perform operation "GRANT" on object "NULLID.SQLL9D06". SQLSTATE=42501::42501][sde.world.greeley_parcels]"

Cause

The user attempted to perform the specified operation on the object without the proper authorization.

If attempting to run a DB2 utility or CLI application, the DB2 utility programs may need to be rebound to the database because the userid who created the database no longer exists or no longer has the required privileges.

Solution or Workaround

To rebind the DB2 utility programs, the following steps need to be performed:

  1. Log in using the db2udb administrator account.
  2. cd db2udb/sqllib/bnd
  3. db2 connect to sde
  4. db2 bind @db2cli.lst grant public blocking all
  5. db2 bind @db2ubind.lst grant public blocking all
  6. db2 disconnect sde