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
 

 

Check User Authorization to a Plan?

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

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Fri Nov 07, 2008 4:54 pm    Post subject: Check User Authorization to a Plan?
Reply with quote

Please let me know how to check the User authorization for a Particular Plan in Mainframe DB2 ? Is there any system tables to refer to ?
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Nov 07, 2008 5:02 pm    Post subject:
Reply with quote

You will probably have to speak with your DBA's and/or security people.

AFAIK this can be done either internally via DB2 or via RACF (ACF2, TOP SECRET, A N Other). So would say initially that this question is site specific.
Back to top
View user's profile Send private message
r2k1984

New User


Joined: 21 Jun 2005
Posts: 69
Location: chennai

PostPosted: Tue Nov 11, 2008 11:25 am    Post subject:
Reply with quote

If the autorization is not there for the plan . the job will abend during compilation with the abend code as -913 .
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Tue Nov 11, 2008 11:53 am    Post subject:
Reply with quote

r2k1984 wrote:
If the autorization is not there for the plan . the job will abend during compilation with the abend code as -913 .


Well if it is not a PROD bind, in other words if it is for testing. Any user in your group who has access to the PLAN can give a grant command to PUBLIC...

SET CURRENT SQLID = '<DB2AUTHID>';
GRANT EXECUTE ON PLAN <PLANNAME>
TO PUBLIC;
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Tue Nov 11, 2008 12:00 pm    Post subject: Reply to: Check User Authorization to a Plan?
Reply with quote

SYSIBM.SYSPLANAUTH table will give you the privileges that are held by users over application plans

You should have DBA access to view this table.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Tue Nov 11, 2008 12:09 pm    Post subject:
Reply with quote

You can check the table SYSIBM.SYSPLANAUTH
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Tue Nov 11, 2008 12:19 pm    Post subject:
Reply with quote

Srihari Gonugunta wrote:
You can check the table SYSIBM.SYSPLANAUTH


All users will not have privilege to check the SYSPLANAUTH table.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Tue Nov 11, 2008 12:21 pm    Post subject: Reply to: Check User Authorization to a Plan?
Reply with quote

but......
if the TS has the need to know, His support will be glad to grant the proper authorizations icon_biggrin.gif
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Tue Nov 11, 2008 12:23 pm    Post subject:
Reply with quote

Agreed, the humbleness of support lies in the necessity of the TS icon_biggrin.gif
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Nov 11, 2008 8:25 pm    Post subject:
Reply with quote

Pardon my ignorance, but what is a "TS"?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Tue Nov 11, 2008 8:35 pm    Post subject: Reply to: Check User Authorization to a Plan?
Reply with quote

TS Topic/Thread Starter
OP Original Post/Poster
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Nov 11, 2008 8:42 pm    Post subject:
Reply with quote

Thanks.
Back to top
View user's profile Send private message
shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Thu Nov 13, 2008 12:34 pm    Post subject: Thanks For all your replies
Reply with quote

Thanks all for your replies
In one of our system a webservice invoked our CICS transactions and abend with authorization issue -922. Spoke with our DBA and things resolved ..
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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts User Cancels the job PANDU1 DB2 1 Sat Mar 04, 2017 8:21 pm


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