GRANT

Purpose

You can use a GRANT statement to grant privileges to other users as the system administrator.

Required privileges

• To execute the GRANT statement, you need to have the granted privilege. For example, if user user1 wants to grant the SELECT privilege on table tbl1 to user user2, then user user1 must have the SELECT privilege on table tbl1.

• To execute the GRANT statement, you need to have the GRANT OPTION privilege. For more information on privileges in OceanBase Database, see Privilege types in MySQL mode.

Syntax

GRANT {priv_type [, priv_type...]}
    ON priv_level
    TO {user [, user...]}
    [WITH GRANT OPTION]

user:
      user_name
    | user_name IDENTIFIED [WITH auth_plugin] BY password
    | user_name IDENTIFIED [WITH auth_plugin] BY PASSWORD password

Parameters

Examples

• Grant the CREATE VIEW privilege on the db1 database to the user1 user and enable privilege delegation.

  obclient> GRANT CREATE VIEW ON db1.* TO user1 WITH GRANT OPTION;
  

• Grant the CREATE privilege on the db1 database to the user1 user and change the password for user1.

  obclient> GRANT CREATE ON db1.* TO user1 IDENTIFIED by '********';
  

  After executing the statement, check the password of user1 in the mysql.user table. The password is updated to the newly set one.

• Grant the CREATE privilege on the db1 database to a non-existing user named user2 and set the password for user2.

  obclient> GRANT CREATE ON db1.* TO user2 IDENTIFIED by '********';
  

References

• For more information about how to grant user privileges, see Grant privileges.

• For more information about how to view user privileges, see View user privileges.

• You can query the mysql.user table to view information about the created user. For more information about the mysql.user table, see mysql.user.