SQL$HELP72.HLB  —  ALTER  ROLE  Arguments  RENAME_TO
    Changes an existing role name to a new role name without
    changing the privileges granted to the role. You might change
    the name of a role that corresponds to a department name when the
    department is renamed. For example, if the personnel department
    is renamed human resources, you might change the role used by
    that department from PERSONNEL to HUMAN_RESOURCES. The new role
    name must not already exist in the database. The old role name is
    removed from the database when the transaction is committed. The
    old role name can be re-created and reused, if desired. If the
    new role name is identified externally, then it must exist as an
    operating system group or rights identifier.

    See the RENAME statement for further discussion.
Close Help