How to Use the Context Variables Across the Forms and Reports Using Fine Grained Access Control(FGAC) (Doc ID 291980.1)

Last updated on OCTOBER 10, 2023

Applies to:

Goal

In Oracle Server 8i, a new functionality to setup row level security and contexts called Fine Grained Access Control (FGAC) was included. Fine Grained Access Control feature can be used to set the context and use it across the session. The objective of FGAC is to dynamically modify a SQL statement in a transparent way to the user by adding a condition (in the WHERE clause) which restricts the rows shown to the user. This allows to set the grants at file level, instead of table level, and a complex process is executed in the database (via package DBMS_RLS).

How to use the context variables across the forms and reports using FGAC.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.