VPD/FGAC on Three Tier Environment

[edsperez]

Has anyone tried or implemented VPD/FGAC on a Three tier environment using a non-oracle application server(Weblogic)?

Please give me or point me to some notes or documentations where I can get more information on how to implement this.

Thanks,

Ed

[dharma]

Hi,
FGAC is going to be on the server side and it should not be a problem on whatever web server you have. We have IIS 5 and 8.17 and it runs fine.
There is a sample file fgacdemo.sql under $ORACLE_HOME/rdbms/demo.
HTH
-dharma

[edsperez]

I have tested FGAC on two tier, I am trying to implement this in three tier. My problem now is database login uses only a single user_id (connection pool). If I am to implement FGAC on three tier;

1. Do I need to specify a special parameters in oracle to make this work on 3 tier?

2. Do I need to make changes on my(package) code that is currently working on TWO TIER?

3. In the package that calls the procedure that sets up the user context. Which parameter do I need to use in place of the 'SESSION_USER' to capture the currently log user? Is it the PROXY_USER or the PROXY_USER_ID?

v_current_user:=SYS_CONTEXT('USERENV','SESSION_USER')

4. What changes is necessary in the JAVA program to implement VPD?

5. What JDBC version are you using.

Thanks,

Ed

[edsperez]

FGAC / VPD Anyone?

[edsperez]

Calling All Oracle Gurus, I need help on this.

[pando]

plz stop repeating no one is blind

[edsperez]

I guess you know the reason why I am doing this, If I don't update this thread new threads will overlay this and the chances of getting a response in this thread gets smalller and smaller.

[pando]

so if everyone acts like you will be the way to go?