Privilege types in MySQL mode|V4.3.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 all columns or the specified columns of a table.
Object privilege	INSERT	The privilege to insert data into all columns or the specified columns of a table.
Object privilege	UPDATE	The privilege to update data in all columns or the specified columns of a table.
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 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 schemas.
Database privilege	CREATE VIEW	The privilege to create views.
Database privilege	SHOW VIEW	The privilege to query views or learn how views operate.
Database privilege	CREATE ROUTINE	The privilege to create procedures and functions.
Database privilege	ALTER ROUTINE	The privilege to modify and delete procedures and functions.
Database privilege	EXECUTE	The privilege to execute procedures and functions.
Global privilege	CREATE	The privilege to execute statements such as the `CREATE DATABASE`, `CREATE TABLEGROUP`, and `CREATE TABLE` statements.
Global privilege	ALTER	The privilege to execute statements such as the `ALTER DATABASE`, `ALTER TABLEGROUP`, `RENAME TABLE`, and `ALTER TABLE` statements.
Global privilege	SELECT	The privilege to query data in tables.
Global privilege	INSERT	The privilege to insert row data into tables.
Global privilege	UPDATE	The privilege to modify existing data.
Global privilege	DELETE	The privilege to delete existing data.
Global privilege	DROP	The privilege to execute statements such as the `DROP DATABASE`, `DROP TABLEGROUP`, `DROP TABLE`, and `DROP VIEW` statements.
Global privilege	INDEX	The privilege to create and delete table indexes.
Global privilege	CREATE VIEW	The privilege to create views.
Global privilege	SHOW VIEW	The privilege to query views or learn how views operate.
Global privilege	ALTER TENANT	The privilege to modify tenant information.
Global privilege	ALTER SYSTEM	The privilege to execute the `ALTER SYSTEM` statement.
Global privilege	CREATE RESOURCE POOL	The privilege to create, modify, and delete resource pools.
Global privilege	CREATE RESOURCE UNIT	The privilege to create, modify, and delete resource units.
Global privilege	CREATE DATABASE LINK	The privilege to create database links.
Global privilege	DROP DATABASE LINK	The privilege to drop database links.
Global privilege	CREATE USER	The privilege to execute statements such as the `CREATE USER`, `ALTER USER`, `DROP USER`, `CREATE ROLE`, and `DROP ROLE` statements.
Global privilege	CREATE ROUTINE	The privilege to create procedures and functions.
Global privilege	ALTER ROUTINE	The privilege to modify and delete procedures and functions.
Global privilege	EXECUTE	The privilege to execute procedures and functions.
Global privilege	PROCESS	The privilege to execute the `SHOW PROCESSLIST` statement to view processes of other users.
Global privilege	SHOW DB	The privilege to view all database names on a server, including the names of the databases that are accessible to the user.
Global privilege	FILE	The privilege to execute the `SELECT INTO OUTFILE` and `LOAD DATA INFILE` statements.
Global 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 copying and logging.

Object privilege

CREATE

The privilege to create tables.

Object privilege

SELECT

The privilege to query data in all columns or the specified columns of a table.

Object privilege

INSERT

The privilege to insert data into all columns or the specified columns of a table.

Object privilege

UPDATE

The privilege to update data in all columns or the specified columns of a table.

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 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 schemas.

Database privilege

CREATE VIEW

The privilege to create views.

Database privilege

SHOW VIEW

The privilege to query views or learn how views operate.

Database privilege

CREATE ROUTINE

The privilege to create procedures and functions.

Database privilege

ALTER ROUTINE

The privilege to modify and delete procedures and functions.

Database privilege

EXECUTE

The privilege to execute procedures and functions.

Global privilege

CREATE

The privilege to execute statements such as the CREATE DATABASE, CREATE TABLEGROUP, and CREATE TABLE statements.

Global privilege

ALTER

The privilege to execute statements such as the ALTER DATABASE, ALTER TABLEGROUP, RENAME TABLE, and ALTER TABLE statements.

Global privilege

SELECT

The privilege to query data in tables.

Global privilege

INSERT

The privilege to insert row data into tables.

Global privilege

UPDATE

The privilege to modify existing data.

Global privilege

DELETE

The privilege to delete existing data.

Global privilege

DROP

The privilege to execute statements such as the DROP DATABASE, DROP TABLEGROUP, DROP TABLE, and DROP VIEW statements.

Global privilege

INDEX

The privilege to create and delete table indexes.

Global privilege

CREATE VIEW

The privilege to create views.

Global privilege

SHOW VIEW

The privilege to query views or learn how views operate.

Global privilege

ALTER TENANT

The privilege to modify tenant information.

Global privilege

ALTER SYSTEM

The privilege to execute the ALTER SYSTEM statement.

Global privilege

CREATE RESOURCE POOL

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

Global privilege

CREATE RESOURCE UNIT

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

Global privilege

CREATE DATABASE LINK

The privilege to create database links.

Global privilege

DROP DATABASE LINK

The privilege to drop database links.

Global privilege

CREATE USER

The privilege to execute statements such as the CREATE USER, ALTER USER, DROP USER, CREATE ROLE, and DROP ROLE statements.

Global privilege

CREATE ROUTINE

The privilege to create procedures and functions.

Global privilege

ALTER ROUTINE

The privilege to modify and delete procedures and functions.

Global privilege

EXECUTE

The privilege to execute procedures and functions.

Global privilege

PROCESS

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

Global privilege

SHOW DB

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

Global privilege

FILE

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

Global 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 copying and logging.