| |
- Causa
- auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name.
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
|
| |
