View previous topic :: View next topic
|
Author |
Message |
MoLong
New User
Joined: 07 Feb 2007 Posts: 32 Location: Chennai
|
|
|
|
Hi,
I tried to DCLGEN a table from a normal login. I got the error:
"DSNE106E PLAN DSNEDCL NOT AUTHORISED FOR SUBSYSTEM MYSYS AND AUTHID MYAUID".
I connected thru a admin account and issued the command
"GRANT EXECUTE ON DSNEDCL TO PUBLIC"
but i get the error "DSNEDCL IS AN UNDEFINED NAME".
How do i
1. make user MYAUID to use DCLGEN.
2. assign execute plan previlege to users.
Thanks in advance.
MoLong. |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi ,
According to input given by you, it seems that plan DSNEDCL is not available in your DB2 subsystem. So, you will have to bind package and plan for DCLGEN then try to execute grant statements.
You can find the bind statements in installation job "DSNTIJSG? (you can find this job in Db2 sample library DSNx10. **.SDSNSAMP).
Code: |
BIND PACKAGE (DSNEDCL) MEMBER (DSNECP68) -
ACTION (REPLACE) ISOLATION (CS) ENCODING (EBCDIC) -
LIBRARY ('DSN810.SDSNDBRM')
BIND PLAN (DSNEDCL) PKLIST (*.DSNEDCL.DSNECP68) -
ISOLATION (CS) ENCODING (EBCDIC) ACTION (REPLACE) |
After bind the plan DSNEDCL, try to grant the execute privilege on the plan to public.
Code: |
GRANT EXECUTE ON DSNEDCL TO PUBLIC |
I hope this helpful for you.
Thanks and Regards
Senthil |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Thanks senthilssg.
I too didnt know this concept. I would have raised this to SYSADM. Here after i will try myself, provided i have access. |
|
Back to top |
|
|
MoLong
New User
Joined: 07 Feb 2007 Posts: 32 Location: Chennai
|
|
|
|
Thanks Senthil.
Will try your solution and report the progress.
ML. |
|
Back to top |
|
|
|