Grant of Delete Authority

[Steve Roy]

We grant this authorization to our data centre staff so they can run a specific batch job.
Where do I look to see who has this, or any other, authority?  Is it stored in a Dictionary table?

[Kevin Shuma]

Steve,

I guess I need greater detail on what you are asking to provide any insight.  
In general, Datacom stores minimal permissions type information in Dictionary.  Typically that information is related Ideal or Dataquery executions.

If you want you can email me directly,

Thanks 

kevin
[e-mail]

[Steve Roy]

Kevin,

 

Thanks for taking the time with this.

 

We use one or the other query statements depending on if the person is coming into or leaving the DCO user group.  The batch program, that runs the row deletes, is a MetaCOBOL app.

 

The table has the following shown in a CXX report:

OCCURRENCE - DECRYPT-SECURITY-LOG P003

SQL SECURITY - YES                   

 

*/            FOR NEW OPER TO BE ABLE TO RUN FM11700 TO PURGE DSL /*

*/REVOKE SELECT,DELETE                                             

   ON SYSADM.DECRYPT_SECURITY_LOG                                   

   FROM DC35                                                       

*/GRANT SELECT,DELETE                                              

   ON SYSADM.DECRYPT_SECURITY_LOG                                  

   TO JERW