Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
C. A. Dornelles
SQL - SQLCODE's - Códigos positivos
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +551
auth-id
DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
operation
ON OBJECT
object-name
Causa
Authorization ID
auth-id
has attempted to perform the specified
operation
on object
object-name
without having been granted the proper authority to do so. This error might also occur if the specified object does not exist, or if the object is a read-only view (for UPDATE or INSERT). Additionally, the error may occur if
auth-id
is trying to create a table or view with an authorization ID other than its own. You may create a table or view from an
auth-id
other than your own only if your authorization ID is SYSADM, DBADM, or DBCTRL.
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.
Ação do sistema
A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement.
Resposta ao Desenvolvedor
For better performance, rebind the plan or package after correcting the statement. To correct the statement, ensure that
auth-id
has been granted the authority to perform the desired operation, that
object-name
exists, and that
auth-id
is not trying to create a table with a different authorization ID.
SQLSTATE: 01548
