Page 1 of 1

SPUFI DSNESPCS plan getting deleted

PostPosted: Wed Sep 25, 2013 8:52 am
by poojithas
Hi,
We found that SPUFI DSNESPCS plan is being deleted by users. First thing how to protect this plan from deletion and secondly we would like to know which user is deleting the plan. Please help.
I have SYSADM authority.

Re: SPUFI DSNESPCS plan getting deleted

PostPosted: Wed Sep 25, 2013 7:38 pm
by dick scherrer
Hello,

Why do these users believe this is acceptable?

Re: SPUFI DSNESPCS plan getting deleted

PostPosted: Wed Sep 25, 2013 8:37 pm
by Akatsukami
More to the point, how is it that everyone and his cat has authority to free it? Would they not have to have BIND granted from the owner, or SYSCTRL or SYSADM, to do so?

Re: SPUFI DSNESPCS plan getting deleted

PostPosted: Thu Sep 26, 2013 5:34 am
by poojithas
I checked in SYSIBM.SYSPLANAUTH and PUBLIC has only EXECUTEAUTH on plan DSNESPCS.
I came to know that users are freeing the plan from DB2 panel 5.3 FREE PLAN on mainframe.

Re: SPUFI DSNESPCS plan getting deleted

PostPosted: Thu Sep 26, 2013 3:41 pm
by Akatsukami
poojithas wrote:I checked in SYSIBM.SYSPLANAUTH and PUBLIC has only EXECUTEAUTH on plan DSNESPCS.

Presumably there are no grants to individual authids?
I came to know that users are freeing the plan from DB2 panel 5.3 FREE PLAN on mainframe.

This doesn't sound like a standard DB2 installation to me. You may wish to do a little checking into how this works.