Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Authorization failure -922

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
lalit.bakde

New User


Joined: 12 Jul 2006
Posts: 7

PostPosted: Thu Sep 20, 2007 8:51 pm    Post subject: Authorization failure -922
Reply with quote

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 icon_question.gif
Back to top
View user's profile Send private message

twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Thu Sep 20, 2007 9:21 pm    Post subject:
Reply with quote

Lalit,

You know the reason... 'Insufficient Authority'.

GRANT SELECT access to the UserId that's accessing the tables.

Cheers, T.
Back to top
View user's profile Send private message
lalit.bakde

New User


Joined: 12 Jul 2006
Posts: 7

PostPosted: Fri Sep 21, 2007 4:22 pm    Post subject:
Reply with quote

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
View user's profile Send private message
twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Fri Sep 21, 2007 4:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ALLOCATE REXX PDS to SYSPROC failure mambopras CLIST & REXX 4 Sat Apr 04, 2015 10:14 am
No new posts Authorization for compiling and linki... Abhi Nature All Other Mainframe Topics 5 Thu Mar 12, 2015 3:09 pm
No new posts OPC/Tivoli OCL failure (line 1560) David Robinson IBM Tools 14 Mon Dec 01, 2014 7:13 am
No new posts FTINCL failure code 20 Invalid contro... Steve Coalbran TSO/ISPF 2 Mon Aug 04, 2014 10:44 am
No new posts Specific authorization for a REXX pro... girishbs13 CLIST & REXX 12 Thu Jun 12, 2014 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us