|
View previous topic :: View next topic
|
| Author |
Message |
shrinivasabharathi_b
New User
Joined: 04 Nov 2008
Posts: 11
Location: Chennai
|
|
|
|
| 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 |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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 |
|
|
r2k1984
New User
.jpg)
Joined: 21 Jun 2005
Posts: 69
Location: chennai
|
|
|
|
| If the autorization is not there for the plan . the job will abend during compilation with the abend code as -913 . |
|
| Back to top |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
| 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 |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
| You can check the table SYSIBM.SYSPLANAUTH |
|
| Back to top |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
| Srihari Gonugunta wrote: |
| You can check the table SYSIBM.SYSPLANAUTH |
All users will not have privilege to check the SYSPLANAUTH table. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
but......
if the TS has the need to know, His support will be glad to grant the proper authorizations  |
|
| Back to top |
|
|
VVRAVINDRA
New User
Joined: 04 Aug 2008
Posts: 46
Location: Chennai
|
|
|
|
| Agreed, the humbleness of support lies in the necessity of the TS |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Pardon my ignorance, but what is a "TS"? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
TS Topic/Thread Starter
OP Original Post/Poster |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Thanks. |
|
| Back to top |
|
|
shrinivasabharathi_b
New User
Joined: 04 Nov 2008
Posts: 11
Location: Chennai
|
|
|
|
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 |
|
|
|
|
