Question: how to disable fga policy in oracle?
Answer: To remove an FGA policy, use the DROP_POLICY procedure in the DBMS_FGA package. For example, to drop the policy we defined earlier on the EMP table, you might specify the following block of code. If the policy does not exist, it will throw the error ORA-28102: policy does not exist.