logo Diese Seite zu Mister Wong hinzu
Google
 

DB2 SQL-Error: -551

SQLState: 42501

Short Description: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT C I SQL I ID DB DB ID R P V DB A G ID I SQL I DROP PACKAGE ID T I ID EXECUTE SQL SQL AB V SQLCODE SQLCODE CURRENT RULES STD S T I A C P E ID

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.

 <-  BACK TO INDEX