Example 1: Renaming a Role

    SQL> -- Change the name of the role from WRITER to DOCUMENTATION.
    SQL> -- Any privileges granted to the role WRITER are transferred to the role
    SQL> -- DOCUMENTATION. The role WRITER is deleted from the database.
    SQL> ALTER ROLE WRITER
    cont> RENAME TO DOCUMENTATION;
    SQL> SHOW ROLES;
    Roles in database with filename mf_personnel.rdb
         DOCUMENTATION