发表于2008/10/3 9:47:00 1055人阅读
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:
Oracle FGAC would modify the statement to read:
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.