RENAME USER

Purpose

You can use this statement to modify the username of a user that has logged on to OceanBase Database.

Note

To execute this statement, you must have the CREATE USER privilege.

Syntax

RENAME USER 
    'old_user_name' TO 'new_user_name'
  [,'old_user_name' TO 'new_user_name'...];

Parameters

Examples

1. Before you modify the username, execute the following statement to query the user.

   Result:

   obclient> SELECT user FROM mysql.user;
   +-----------+
    user      
   +-----------+
    root      
    admin     
    sqluser01 
    sqluser02 
   +-----------+
   4 rows in set (0.00 sec)
   

2. Execute the following statement to change the username of sqluser01 to obsqluser01.

   obclient> RENAME USER 'sqluser01' TO 'obsqluser01';
   

3. After you modify the username, execute the following statement to query the user. Result:

   The username of sqluser01 has been changed to obsqluser01.

   obclient> RENAME USER 'sqluser01' TO 'obsqluser01';
   Query OK, 0 rows affected (0.04 sec)
   
   obclient> SELECT user FROM mysql.user;
   +-------------+
    user        
   +-------------+
    root        
    admin       
    obsqluser01 
    sqluser02   
   +-------------+
   4 rows in set (0.00 sec)