Renaming security objects

Use the RENAME SECURITY statement to rename a security policy, a security label, or a security label component.

You must hold the DBSECADM role to rename a security object.

The three valid clauses for the RENAME SECURITY statement are as follows:

POLICY old_name TO new_name renames a security policy
- Example: RENAME SECURITY POLICY company TO subsidiary; renames the policy named company to subsidiary
LABEL security_policy.old_name TO new_name renames a security label; in this statement you also indicate the security policy to which the label belongs
- Example: RENAME SECURITY LABEL subsidiary.label8 TO label9; renames label8 to label9, which belongs to security policy subsidiary
LABEL COMPONENT old_name TO new_name specifies a security label component
- Example: RENAME SECURITY LABEL COMPONENT department TO division; renames the component department to division.
For more information about the RENAME SECURITY statement, see HCL Informix® Guide to SQL: Syntax.

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, or sysseclabelcomponents.compid of the renamed security object.