Grouped Policy Wizard (Oracle)
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:
- Click Schema, and then click Grouped Policies.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Grouped Policy Wizard (Oracle) - Properties.
- Column Selection panel - for details, see Grouped Policy Wizard (Oracle) - Column Selection.
- Additional Properties panel - for details, see Grouped Policy Wizard (Oracle) - Additional Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Finish button to create the object.
Contents
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. |
Name |
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. |
Enable |
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
- Initiate a Refresh Grouped Policy action against one or more grouped policies. For more information, see Initiating an object operation.
- 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. |
Dependencies |
Something |
Preview |
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.