The DBMS_RLS system package provides row-level security management features. Using this package, you can define security policies for database tables or views to control user access rights to data rows.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Overview of DBMS_RLS Subprograms
The following table lists the DBMS_RLS subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| ADD_POLICY | Adds fine-grained access control policies for tables or views. |
| DROP_POLICY | Delete a security policy from a specified table or view. |
| ENABLE_POLICY | Enables or disables security policies on a specified table or view. |
| ALTER_POLICY | Modify the namespace and attribute association of a policy. |
| ADD_POLICY_CONTEXT | Adds a context association to the policy. |
| DROP_POLICY_CONTEXT | Delete the context association of the policy. |
| REFRESH_POLICY | Refresh the specified policy. |
| REFRESH_GROUPED_POLICY | Refresh group strategy. |
| CREATE_POLICY_GROUP | Create a policy group. |
| DELETE_POLICY_GROUP | Delete a policy group. |
| ADD_GROUPED_POLICY | Adds a policy to the specified policy group. |
| DROP_GROUPED_POLICY | Deletes a policy from the specified policy group. |
| ENABLE_GROUPED_POLICY | Enables a policy from the specified policy group. |
| DISABLE_GROUPED_POLICY | Disable a policy in the specified policy group. |
| ALTER_GROUPED_POLICY | Modify the namespace and attribute association of a grouping strategy. |