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';
I cannot confirm if there is any simpler way for doing that, but below are some of the views where in you can find the Enabled policies and other details for the FGA policies..
DBA_SA_USER_PRIVS, SA_POLICY_ADMIN, SA_LABEL_ADMIN, DBA_SA_SCHEMA_POLICIES, DBA_SA_TABLE_POLICIES