Renames an existing user.

Syntax

---

RENAME USER <Name> TO <Name>

Usage

---

Use this statement to rename a user.

Examples

---

-- The following statement renames the "Joe Smith"
-- user as "John Doe"

RENAME USER "Joe Smith" TO "John Doe"

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: