Privilege types in MySQL mode|V4.2.1|OceanBase Database|docs|OceanBase Documentations

Type	Privilege	Description
Object privilege	CREATE	The privilege to create tables.
Object privilege	SELECT	The privilege to query data in tables.
Object privilege	INSERT	The privilege to insert row data into tables.
Object privilege	UPDATE	The privilege to modify existing data.
Object privilege	DELETE	The privilege to delete existing data.
Object privilege	DROP	The privilege to drop existing tables and views.
Object privilege	INDEX	The privilege to create and delete table indexes.
Object privilege	ALTER	The privilege to rename and modify table schemas.
Object privilege	CREATE VIEW	The privilege to create views.
Object privilege	SHOW VIEW	The privilege to query views or learn how views operate.
Database privilege	SELECT	The privilege to query data in tables.
Database privilege	INSERT	The privilege to insert row data into tables.
Database privilege	UPDATE	The privilege to modify existing data.
Database privilege	DELETE	The privilege to delete existing data.
Database privilege	CREATE	The privilege to create databases and tables.
Database privilege	DROP	The privilege to drop existing databases, tables, and views.
Database privilege	INDEX	The privilege to create and delete table indexes.
Database privilege	ALTER	The privilege to rename and modify table schemas.
Database privilege	CREATE VIEW	The privilege to create views.
Database privilege	SHOW VIEW	The privilege to query views or learn how views operate.
Administrator privilege	CREATE	The privilege to create databases, table groups, and tables.
Administrator privilege	ALTER	The privilege to modify table groups, and rename and modify table schemas.
Administrator privilege	SELECT	The privilege to query data in tables.
Administrator privilege	INSERT	The privilege to insert row data into tables.
Administrator privilege	UPDATE	The privilege to modify existing data.
Administrator privilege	DELETE	The privilege to delete existing data.
Administrator privilege	DROP	The privilege to drop existing databases, table groups, tables, and views.
Administrator privilege	INDEX	The privilege to create and delete table indexes.
Administrator privilege	CREATE VIEW	The privilege to create views.
Administrator privilege	SHOW VIEW	The privilege to query views or learn how views operate.
Administrator privilege	ALTER TENANT	The privilege to modify tenant information.
Administrator privilege	ALTER SYSTEM	The privilege to execute the `ALTER SYSTEM` statement.
Administrator privilege	CREATE RESOURCE POOL	The privilege to create, modify, and delete resource pools.
Administrator privilege	CREATE RESOURCE UNIT	The privilege to create, modify, and delete resource units.
Administrator privilege	CREATE DATABASE LINK	The privilege to create a database link.
Administrator privilege	DROP DATABASE LINK	The privilege to drop a database link.
Administrator privilege	CREATE USER	The privilege to execute the `CREATE USER` statement to create MySQL accounts.
Administrator privilege	PROCESS	The privilege to execute the `SHOW PROCESSLIST` statement to view processes of other users.
Administrator privilege	SHOW DATABASES	The privilege to view all database names on a server, including the names of the databases that are accessible to the user.
Administrator privilege	FILE	The privilege to execute the `SELECT INTO OUTFILE` and `LOAD DATA INFILE` statements.
Administrator privilege	SUPER	The privilege to perform some advanced management operations, such as deleting a user process by using the `KILL` statement, modifying global MySQL variables by using the `SET GLOBAL` statement, and running various commands related to replication and logging.

Object privilege

CREATE

The privilege to create tables.

Object privilege

SELECT

The privilege to query data in tables.

Object privilege

INSERT

The privilege to insert row data into tables.

Object privilege

UPDATE

The privilege to modify existing data.

Object privilege

DELETE

The privilege to delete existing data.

Object privilege

DROP

The privilege to drop existing tables and views.

Object privilege

INDEX

The privilege to create and delete table indexes.

Object privilege

ALTER

The privilege to rename and modify table schemas.

Object privilege

CREATE VIEW

The privilege to create views.

Object privilege

SHOW VIEW

The privilege to query views or learn how views operate.

Database privilege

SELECT

The privilege to query data in tables.

Database privilege

INSERT

The privilege to insert row data into tables.

Database privilege

UPDATE

The privilege to modify existing data.

Database privilege

DELETE

The privilege to delete existing data.

Database privilege

CREATE

The privilege to create databases and tables.

Database privilege

DROP

The privilege to drop existing databases, tables, and views.

Database privilege

INDEX

The privilege to create and delete table indexes.

Database privilege

ALTER

The privilege to rename and modify table schemas.

Database privilege

CREATE VIEW

The privilege to create views.

Database privilege

SHOW VIEW

The privilege to query views or learn how views operate.

Administrator privilege

CREATE

The privilege to create databases, table groups, and tables.

Administrator privilege

ALTER

The privilege to modify table groups, and rename and modify table schemas.

Administrator privilege

SELECT

The privilege to query data in tables.

Administrator privilege

INSERT

The privilege to insert row data into tables.

Administrator privilege

UPDATE

The privilege to modify existing data.

Administrator privilege

DELETE

The privilege to delete existing data.

Administrator privilege

DROP

The privilege to drop existing databases, table groups, tables, and views.

Administrator privilege

INDEX

The privilege to create and delete table indexes.

Administrator privilege

CREATE VIEW

The privilege to create views.

Administrator privilege

SHOW VIEW

The privilege to query views or learn how views operate.

Administrator privilege

ALTER TENANT

The privilege to modify tenant information.

Administrator privilege

ALTER SYSTEM

The privilege to execute the ALTER SYSTEM statement.

Administrator privilege

CREATE RESOURCE POOL

The privilege to create, modify, and delete resource pools.

Administrator privilege

CREATE RESOURCE UNIT

The privilege to create, modify, and delete resource units.

Administrator privilege

CREATE DATABASE LINK

The privilege to create a database link.

Administrator privilege

DROP DATABASE LINK

The privilege to drop a database link.

Administrator privilege

CREATE USER

The privilege to execute the CREATE USER statement to create MySQL accounts.

Administrator privilege

PROCESS

The privilege to execute the SHOW PROCESSLIST statement to view processes of other users.

Administrator privilege

SHOW DATABASES

The privilege to view all database names on a server, including the names of the databases that are accessible to the user.

Administrator privilege

FILE

The privilege to execute the SELECT INTO OUTFILE and LOAD DATA INFILE statements.

Administrator privilege

SUPER

The privilege to perform some advanced management operations, such as deleting a user process by using the KILL statement, modifying global MySQL variables by using the SET GLOBAL statement, and running various commands related to replication and logging.