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