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


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;