RENAME SECURITY statement

Use the RENAME SECURITY statement to change the name of an existing security object. The object can be a security policy, or a security label, or a security label component.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-RENAME SECURITY--+-POLICY-----------+------------------------>
                    +-LABEL--policy--.-+   
                    '-LABEL COMPONENT--'   

>--old_name--TO--new_name--------------------------------------><

Element Description Restrictions Syntax
new_name New name that you declare here for the security object Must be unique among identifiers of security objects in the database, and must be different from old_name Identifier
old_name Current® name that new_name replaces Must exist in the database as the identifiers of a security object Identifier
policy Security policy of the old_name label Must be the security policy for which old_name is a security label Identifier

Usage

This statement is an extension to the ANSI/ISO standard for SQL.

Only DBSECADM can issue this statement. The RENAME SECURITY statement replaces the old_name with the specified new_name in the table of the system catalog in which the renamed security object is registered:
  • sysecpolicies.secpolicyname for security policies
  • sysseclabels.seclabelname for security labels
  • sysseclabelcomponents.compname for security label components.
This statement does not, however, change the numeric value of the sysecpolicies.secpolicyid, sysseclabels.seclabelid, nor sysseclabelcomponents.compid of the renamed security object.
The keyword or keywords that follow the SECURITY keyword identify the type of security object that is being renamed. In the following example, the new identifier honesty replaces best as the name of a security policy:
RENAME SECURITY POLICY best TO honesty;
In the following example, the new identifier transparent replaces opaque as the name of a label for the honesty security policy:
RENAME SECURITY LABEL honesty.opaque TO transparent;
In the next example, the new identifier accountant replaces architect as the name of a security label component:
RENAME SECURITY LABEL COMPONENT architect TO accountant;

Copyright© 2019 HCL Technologies Limited