Database Security Products (MOSC)

MOSC Banner

How to use fgac(dbms_rls) to disallow update on a Column based on value from other Tables Column ?

edited Nov 21, 2023 3:53PM in Database Security Products (MOSC) Question

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center