Database Security Products (MOSC)

MOSC Banner

FGAC - 11gr2

edited May 1, 2014 12:00PM in Database Security Products (MOSC) 1 commentAnswered

Hi all, Can you please let me know how to add fgac policy for the following piece of code that involves where clause and two tables? It is simple and easy when doing for  all  or selected columns of a table.

I will appreciate if you can list the steps. Also what is the difference between FGAC and RLS pkgs and what to use and when?




SELECT AMRCONF_PIDM, AMRCONF_COMMENT

  FROM AMRCONF, APRCATG

WHERE AMRCONF_PIDM = APRCATG_PIDM

     AND APRCATG_DONR_CODE ='PROS'


Thanks in advance,

VP



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