SQL - SQLCODE's - Códigos negativos -551


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -551
   
 
  • Causa
    • auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name

      Authorization ID auth-id attempted to perform operation on object object-name without having been granted the proper authority to do so.
      This error might also occur if the object is a read-only view (for INSERT, DELETE, or UPDATE), or if auth-id is trying to create a table or view with an authorization ID other than its own.

      You can create a table from an auth-id other than your own only if your authorization ID is SYSADM, DBADM, or DBCTRL.
      You can create a view from an auth-id other than your own only if your authorization ID is SYSADM.

      When operation is ’GRANT ***’, the keyword ALL was used in the GRANT statement, but the grantor auth-id did not possess any privilege to grant.

      If this error occurs while DB2 is creating or altering a table involving referential constraints, this code reports that the user does not have the necessary ALTER privilege to perform a FOREIGN KEY, DROP FOREIGN KEY, DROP PRIMARY KEY, or DROP UNIQUE operation.
      The object-name identifies the object table of the CREATE or ALTER TABLE statement, not the table for which the user lacks the ALTER privilege.

      If this error occurs for a distributed SQL request, then:
      1. If authorization ID translation is in effect for either the requesting DB2 site or the serving (responding) DB2 site, then auth-id is the translated authorization ID.
        Refer to Part 3 (Volume 1) of DB2 Administration Guide for information on authorization ID translation.
      2. If an alias name was used in the SQL statement, then object-name is the resolved remote table or view name.

      If the operation is a DROP PACKAGE, the object name consists of the collection ID, the package name and the consistency token.
      The consistency token uniquely identifies which version of the package the user does not have authorization to drop.

      Nota: Beginning with Version 5, SQLCODE -551 will be returned instead of SQLCODE -204 for the runtime error where an object does not exist and the CURRENT RULES special register is set to ’STD’.

  • Ação do sistema
    • The statement cannot be executed.
      Check for an attempted authorization violation.
  • Resposta ao Desenvolvedor
    • Ensure that auth-id was granted the authority to perform the desired operation, the object-name exists, and auth-id is not trying to create a table with a different authorization ID.

      SQLSTATE: 42501

© Copyright IBM Corp.