|
View previous topic :: View next topic
|
| Author |
Message |
lalit.bakde
New User
Joined: 12 Jul 2006
Posts: 7
|
|
|
|
Hi All
I'm getting authorization failure (sqlcode -922, sqlstate 42505) abend
while retrieving data from DB2 table(simple select query).
I'm invoking a CICS program thru the Java frontend. This CICS program
takes input from Java, retrieves data from DB2 table and sends it back to
Java.
Can anyone tell me what would be the issue  |
|
| Back to top |
|
 |
twissi
Active User
Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ
|
|
|
|
Lalit,
You know the reason... 'Insufficient Authority'.
GRANT SELECT access to the UserId that's accessing the tables.
Cheers, T. |
|
| Back to top |
|
|
lalit.bakde
New User
Joined: 12 Jul 2006
Posts: 7
|
|
|
|
Twissi,
Thanks.
Is there any way to check the access rights for the UserId which
I am using for connecting to CICS. Since my ID has access
to use SPUFI for select. If so, how to get that access right..? |
|
| Back to top |
|
|
twissi
Active User
Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ
|
|
|
|
Identify which user id's accessing the table and request your system support guys to GRANT the right access to that Id.
To know the group level access, you could use TSO LU <UserId>.
Twissi. |
|
| Back to top |
|
|
|
|
