How to get a list of all simple users (User@Host or Domain) created in autosys_secure?

Document ID : KB000053162
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

In autosys_secure, AutoSys User@Host or Domain password, client has used the number [4] option to create several users on a domain but cannot consult a complete list of all the users they created in order to double check their accuracy and spelling. The Show option exists only for superusers while client needs to get the list of simple users following an unknown user error.

Solution

The solution is to consult the database using the following query:

select * from cred where owner like '%username%'; 

Important Note: This method can be used only for Consulting information and in case you need to do some updates, it is necessary to do it through autosys_secure utility, otherwise you may risk a database corruption.
Any manual updates or deletes on cred table is strongly prohibited and not supported.