This content has been marked as final. Show 3 replies
grant select_catalog_role to FORTIDB;
grant delete_catalog_role to FORTIDB;
grant audit any to FORTIDB;
grant audit system to FORTIDB;
grant select on sys.aud$ to FORTIDB;
You probably need to grant SYS.AUD$ as the SYS user.
GRANT AUDIT ANY TO FORTIDB; GRANT AUDIT SYSTEM TO FORTIDB; GRANT CREATE SESSION TO FORTIDB; GRANT SELECT ANY TABLE TO FORTIDB; GRANT DELETE_CATALOG_ROLE TO FORTIDB; GRANT SELECT_CATALOG_ROLE TO FORTIDB; GRANT SELECT ON SYS.AUD$ TO FORTIDB;
If you don't have the user you need to create it first.
Replace the <password> with whatever you want to use for the password. Then run the GRANTS SQL as shown above.
CREATE USER FORTIDB IDENTIFIED BY <password> PROFILE "DEFAULT";
Thank you! very much for such a quick response and complete answer. I will forward this to the client.