Joined: 05 Oct 2005 Posts: 309 Location: Vizag / US
i'll completly agree what PeD said.
here is some more info regarding ur error and resolution.
Explanation: 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.
Resolution : 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.