After observing the permissions in database for user "aedbadmin",
we have noticed that there is a SELECT privilege on DBA_TABLESPACES assigned to the UJOADMIN role.
Please confirm is it necessary for application to have such permissions.
and any other alternatives if possible. Can you confirm why "SELECT privileges on dba_tables and dba_tablespacs" are required?
The UJOADMIN role besides having a SELECT, DELETE, INSERT, UPDATE and EXECUTE on AutoSys tables and stored procedures
would also require the SELECT privileges on dba_tables and dba_tablespaces.
It would also require ANALYZE ANY for the dbstatistics and dbspace to work properly.
The "SELECT privileges on the dba_tables and dba_tablespacs" are required for database maintenance tasks specially the "dbspace" utility.