How to use fgac(dbms_rls) to disallow update on a Column based on value from other Tables Column ?
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Wanted to disallow a update on a column based on the status of the unique id of this record on other table.
ie. say 1. Table Emp has empno, Gender , 2. Table Emp_Status has Empno, Status
Now, Gender in Emp Table should be disallowed to be updated, based on the Status Column in Emp_Status.
Can this be achieved using dbms_rls Package?