VPD/FGAC on Three Tier Environment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: VPD/FGAC on Three Tier Environment

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Cool

    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

  2. #2
    Join Date
    Dec 2000
    Posts
    138

    should work

    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

  3. #3
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Still on FGAC and Three Tier

    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

  4. #4
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    FGAC / VPD Anyone?

  5. #5
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    Calling All Oracle Gurus, I need help on this.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    plz stop repeating no one is blind

  7. #7
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    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.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    so if everyone acts like you will be the way to go?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width