1 Reply Latest reply on Aug 1, 2019 5:02 AM by Gaurav Kamal - Oracle-Oracle

    Discover the FGA commands executed in a DB

    kazyskiyn0w

      Hi,

       

      A DBA who left the company implemented FGA auditing in one database. And now I need to execute the same on other databases. Does anyone know if there is a SQL that I can perform a "reverse engineering" to discover the FGA commands that were executed by the DBA who left the Company? Being simplistic, just like the query we use, for example, to create synonyms implemented in one DB and execute the same in other Database :

      select 'create public synonym ' || synonym_name || ' for ' || table_owner || '.' || table_name || ';' from dba_synonyms where owner = 'PUBLIC' and table_owner = '&user';

       

       

      Thanks,

      Kz