dbms_rls

firefoxboy

于 2008-10-02 19:34:00 发布

阅读量456

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： schema function object null types access

本文链接：https://blog.youkuaiyun.com/firefoxboy/article/details/3009870

Oracle 专栏收录该内容

101 篇文章

订阅专栏

dbms_rls

dbms_rls is used to administer virtual private databases (also called: fine grained access control). rls stands for row level security.

add_policy

DBMS_RLS.ADD_POLICY (

   object_schema   IN VARCHAR2 := NULL,

   object_name     IN VARCHAR2,

   policy_name     IN VARCHAR2,

   function_schema IN VARCHAR2 := NULL,

   policy_function IN VARCHAR2,

   statement_types IN VARCHAR2 := NULL,

   update_check    IN BOOLEAN  := FALSE,

   enable          IN BOOLEAN  := TRUE);