Grouped Policy Wizard (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Wizards

A Grouped Policy is a policy to the specified table, view, or synonym and associates the policy with the specified policy group.

To create a new Grouped Policy using a wizard:

  1. Click Schema, and then click Grouped Policies.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Finish button to create the object.

Grouped Policy Wizard (Oracle) - Properties

When creating or editing a grouped policy, this tab/panel allows you to set values on the following properties:

Property Description

Parent Type

Select the type (TABLE, DATABASE, SCHEMA, or VIEW) of element that this grouped policy is to be associated with.

Parent Schema and Parent Name

If available and appropriate, select the specific object for which the grouped policy is being created.


Provide a name for the grouped policy being created.

Function Schema and Function Name

Provide the schema and name of the function used to create this grouped policy.

Policy Group

Select the name of the policy group associated with the grouped policy you are creating.

Update Check

Check this box to cause the server to check the policy against the value after INSERT or UPDATE statement types. Applies only to INSERT and UPDATE statements and only on the security-relevant columns included in the policy definition.


Enables or disables the grouped policy when added. By default, this checkbox is checked.

Static Policy

Makes the grouped policy static or dynamic. By default, this checkbox is unchecked.

Policy Type

Select the type of the grouped policy you are creating. The default value is NULL, which allow the policy type to be defined by the value of the Status Policy checkbox. Selecting a value in this field overrides the value of the Static Policy checkbox.

Long Predicate

Default is unchecked, allowing a predicate with a length of up to 4000 bytes. Check this box to allow a predicate text string length of up to 32K bytes.

Secondary Relevant Columns Options

Enables security policies when a column containing sensitive information is referenced in a query. Applies to tables and views, but not to synonyms. By default, it applies to all of the user-defined columns for the object.

Statement Types

Select the acceptable value for each type of statement in this grouped policy.

Grouped Policy Wizard (Oracle) - Column Selection

Check the columns you want included in the grouped policy.

Grouped Policy Wizard (Oracle) - Additional Properties

Specify the namespace attribute for the new grouped policy.

Enable / Disable Grouped Policies

DBArtisan allows you to enable and disable Grouped Policies.

To enable or disable Grouped Polices:

Right-click on the Grouped Policy you want to enable or disable, and then select Enable Grouped Policy or Disable Grouped Policy.

Refresh Grouped Policies

The Refresh Grouped Policy dialog lets you reload grouped policies that have been defined with refresh options.

To Refresh a Grouped Policy

  1. Initiate a Refresh Grouped Policy action against one or more grouped policies. For more information, see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings on the Refresh Grouped Policy dialog:
Pane Description

Action Options

Select an Online Option of ALLOW NO ACCESS, ALLOW READ ACCESS or ALLOW WRITE ACCESS. Enable or disable Query Optimization. Select an INCREMENTAL or NOT INCREMENTAL Refresh Option.




Preview the DDL generated by the options you chose. For more information, see [[[Using object operation wizards|Preview]].

3. Click Execute. For information on the scheduling option, see Scheduling.