ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle之FGAC(Fine Grainted Access)

oracle之FGAC(Fine Grainted Access)

原创 Linux操作系统 作者:流浪的野狼 时间:2013-09-17 15:58:17 0 删除 编辑

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.

来自:http://databases.about.com/b/2008/04/10/oracle-fine-grained-access-control.htm

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28612416/viewspace-772838/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-04-10

  • 博文量
    151
  • 访问量
    1519952