This topic describes the privileges of a regular account in the MySQL compatible and Oracle compatible modes of OceanBase Cloud.
Account privileges in the MySQL compatible mode
The default privilege of a regular account in the MySQL compatible mode is SELECT on information_schema.*.
| Privilege type | Privilege | Description |
|---|---|---|
| Read/Write privilege | ALL PRIVILEGES | All privileges except GRANT OPTION. |
| Read-only privilege | CREATE SESSION | The privilege to connect to a database. |
| Read-only privilege | SELECT | The privilege to query data in tables. |
| Read-only privilege | SHOW VIEW | The privilege to query views and learn how views operate. |
| DDL-only | CREATE | The privilege to create tables. |
| DDL-only | DROP | The privilege to drop tables and views. |
| DDL-only | ALTER | The privilege to rename tables and modify schemas. |
| DDL-only | SHOW VIEW | The privilege to query views and learn how views operate. |
| DDL-only | CREATE VIEW | The privilege to create views. |
| DML-only | SELECT | The privilege to query data in tables. |
| DML-only | INSERT | The privilege to insert rows into tables. |
| DML-only | UPDATE | The privilege to modify existing data. |
| DML-only | DELETE | The privilege to delete existing data. |
| DML-only | SHOW VIEW | The privilege to query views and learn how views operate. |
| DML-only | PROCESS | The privilege to use the SHOW PROCESSLIST statement to view the processes of other users. |
Account privileges in the Oracle compatible mode
By default, a regular account in the Oracle compatible mode has the following privileges on user schemas.
| Privilege | Description |
|---|---|
| CREATE TABLE | The privilege to create tables. |
| CREATE VIEW | The privilege to create views. |
| CREATE PROCEDURE | The privilege to create any stored procedures for users. |
| CREATE SYNONYM | The privilege to create synonyms for users. |
| CREATE SEQUENCE | The privilege to create sequences for users. |
| CREATE TRIGGER | The privilege to create triggers for users. |
| CREATE TYPE | The privilege to create types. |
| CREATE SESSION | The privilege to create sessions. |
| EXECUTE ANY PROCEDURE | The privilege to execute any stored procedures. |
| CREATE ANY OUTLINE | The privilege to create any execution plans. |
| ALTER ANY OUTLINE | The privilege to modify any execution plans. |
| DROP ANY OUTLINE | The privilege to drop any execution plans. |
| CREATE ANY PROCEDURE | The privilege to create any stored procedures for users. |
| ALTER ANY PROCEDURE | The privilege to modify any stored procedures. |
| DROP ANY PROCEDURE | The privilege to drop any stored procedure. |
| CREATE ANY SEQUENCE | The privilege to create any sequences. |
| ALTER ANY SEQUENCE | The privilege to modify any sequences. |
| DROP ANY SEQUENCE | The privilege to drop any sequences. |
| CREATE ANY TYPE | The privilege to create any types. |
| ALTER ANY TYPE | The privilege to modify any types. |
| DROP ANY TYPE | The privilege to drop any types. |
| SYSKM | The privilege to perform operations related to transparent data encryption (TDE). |
| CREATE ANY TRIGGER | The privilege to create any triggers for users. |
| ALTER ANY TRIGGER | The privilege to modify any triggers. |
| DROP ANY TRIGGER | The privilege to drop any triggers. |
| CREATE PROFILE | The privilege to create profiles. |
| ALTER PROFILE | The privilege to modify profiles. |
| DROP PROFILE | The privilege to drop profiles. |