oracle之FGAC(Fine Grainted Access)

Oracle's Fine Grained Access Control (FGAC) provides a row-level security mechanism that's built-in to the Oracle database engine. FGAC allows you to granularly specify the exact information elements that each user may access. It works by automatically appending a WHERE predicate to the SQL statements executed by the user. For example, if you had an Employees table and wanted to grant each user access to his or her own records, you could assign them the clause "WHERE employeeid = USER").

With such an FGAC scheme, if the user executed the following statement:
SELECT *
FROM Employees

Oracle FGAC would modify the statement to read:
SELECT *
FROM Employees
WHERE employeeid = USER

Automatically limiting the user's access. For more information on FGAC, read the Oracle article:Fine Grained Access Control and Application Contexts.

來自：