Renaming security objects

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

Before you begin

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

About this task

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

Procedure

  1. POLICY old_name TO new_name renames a security policy
    • Example: RENAME SECURITY POLICY company TO subsidiary; renames the policy named company to subsidiary
  2. 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
  3. 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 OneDB™ Guide to SQL: Syntax.

Results

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:

What to do next

  • 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.