View previous topic :: View next topic
|
Author |
Message |
rambabu Currently Banned New User
Joined: 18 Apr 2005 Posts: 67
|
|
|
|
Iam accessing to DB2 through DB2-FILEAID .It will give error like this
MessSQLP100H DB2 Error: Authorization failure (-551).
How will I solve this error? |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Just normal way : ask your data security team, or people having access to that environment to grant access (select, update, ... ) to your userid. |
|
Back to top |
|
|
Gautam512
Active User
Joined: 05 Oct 2005 Posts: 308 Location: Vizag / US
|
|
|
|
hi,
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. |
|
Back to top |
|
|
soumyaranjan007
New User
Joined: 30 Aug 2006 Posts: 30 Location: mumbai
|
|
|
|
rambabu wrote: |
Iam accessing to DB2 through DB2-FILEAID .It will give error like this
MessSQLP100H DB2 Error: Authorization failure (-551).
How will I solve this error? |
Hi,
You need to get the access authorization for that particular region.
Regards
Soumya Ranjan Pradhan |
|
Back to top |
|
|
|