Query shows EXEC and EDIT on DB?

Products

• CA Workload Automation AE

Issue/Introduction

Rather than manual report from autosys_secure. Do we have the query shows EXEC and EDIT?

Environment

Release : All Supported Versions.

Component : WORKLOAD CONTROL CENTER

Resolution

It is not recommended to run any queries on Schema directly. The EDIT and EXEC users are stored in ujo_keymaster table. Below query should display all the users. 

 

select * from ujo_keymaster