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
 
What is the command to find if my mainframe id access?

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

New User


Joined: 17 Feb 2006
Posts: 1

PostPosted: Fri Mar 26, 2010 7:29 pm    Post subject: What is the command to find if my mainframe id access?
Reply with quote

What is the command to find if my mainframe id have access to a certain plan, or region?

I am getting a SQLCODE = -991 SQLSTATE 57015.

When i googled it i could find,

Have your DB2 admin ensure the userid is authorized to execute the DB2 plan. If not, issue a GRANT EXECUTE on the PLAN for the userid, e.g.

"GRANT EXECUTE ON PLAN EDIENU33 TO wlm_userid"


How to see if i have read/update access to certain plan?
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Mar 26, 2010 9:09 pm    Post subject:
Reply with quote

there is no such thing as read/update authority on a plan.

There is EXECUTE authority on a package and those are found in SYSIBM.SYSPACKAUTH
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 FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 5 Wed Aug 23, 2017 9:59 pm
This topic is locked: you cannot edit posts or make replies. Limit access to certain RACF group cvnlynn CLIST & REXX 5 Wed Aug 23, 2017 2:28 am
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
This topic is locked: you cannot edit posts or make replies. rexx to create a tso command Bharath Vikraman CLIST & REXX 1 Tue Aug 08, 2017 3:32 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm


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