Hi,
While setting up new ORACLE DB for new Autosys instance, we have shared the following prerequisites with DB team,
Database details:
- Oracle 32 bit Full Client on respective AUTOSYS servers.
- User details and Role / privileges are as follows:
- Created database user AEDBADMIN USER with password as ************ and The database aedbadmin user must have the following privileges.
- GRANT CREATE VIEW TO aedbadmin;
- GRANT 'CONNECT' TO aedbadmin;
- GRANT 'RESOURCE' TO aedbadmin;
- GRANT 'SELECT_CATALOG_ROLE' TO aedbadmin;
- GRANT CREATE PUBLIC SYNONYM TO aedbadmin;
- The database ujo_admin role must have the following privileges.
- GRANT ANALYZE ANY TO ujoadmin;
- GRANT SELECT ON DBA_TABLESPACES TO ujoadmin;
- GRANT ujoadmin TO aedbadmin;
- Create database user Autosys with password as **********must have the following privileges.
- GRANT 'CONNECT' TO autosys;
- GRANT ujoadmin TO Autosys;
However, as per DBA,
Please do provide the correct details regarding the GRANTS that needs to be provided as we weren't able to find any "ujoadmin" role
Refer to the below details:
SQL> !hostname
t01ldr00213
SQL> select ROLE from dba_roles where ROLE like '%ujoadmin%';
no rows selected
I have gathered the above prerequisites from CA support information. Is there a change in the DB requirements? have I missed anything or mentioned incorrect details. PLease help.