The REFRESH_POLICY procedure is used to refresh a specified policy. The REFRESH_GROUPED_POLICY procedure is used to refresh a grouped policy.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
REFRESH_POLICY
DBMS_RLS.REFRESH_POLICY(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2 := NULL,
policy_name IN VARCHAR2 := NULL);
REFRESH_GROUPED_POLICY
DBMS_RLS.REFRESH_GROUPED_POLICY(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2 := NULL,
group_name IN VARCHAR2 := NULL,
policy_name IN VARCHAR2 := NULL);
Parameters
Parameter |
Description |
|---|---|
| object_schema | The name of the schema to which the table or view belongs. Default isNULL. |
| object_name | The name of the table or view. Default isNULL. |
| policy_name | Policy name. Default value:NULL. |
| group_name | Policy group name. Default value:NULL. |
Examples
-- Refresh Policy
BEGIN
DBMS_RLS.REFRESH_POLICY(
object_schema => 'hr',
object_name => 'employees',
policy_name => 'emp_policy');
END;
/
-- Refresh Group Policy
BEGIN
DBMS_RLS.REFRESH_GROUPED_POLICY(
object_schema => 'hr',
object_name => 'employees');
END;
/