OceanBase 新建賬號(hào)

新增普通賬戶的默認(rèn)權(quán)限：

• MySQL模式默認(rèn)權(quán)限為：SELECT on information_schema.*
• Oracle模式默認(rèn)權(quán)限為用戶 Schema 上的以下權(quán)限： CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE SYNONYM CREATE SEQUENCE CREATE TRIGGER CREATE TYPE CREATE SESSION EXECUTE ANY PROCEDURE CREATE ANY OUTLINE ALTER ANY OUTLINE DROP ANY OUTLINE CREATE ANY PROCEDURE ALTER ANY PROCEDURE DROP ANY PROCEDURE CREATE ANY SEQUENCE ALTER ANY SEQUENCE DROP ANY SEQUENCE CREATE ANY TYPE ALTER ANY TYPE DROP ANY TYPE SYSKM CREATE ANY TRIGGER ALTER ANY TRIGGER DROP ANY TRIGGER CREATE PROFILE ALTER PROFILE DROP PROFILE

MySQL模式下賬戶可以對(duì)數(shù)據(jù)庫(kù)的以下權(quán)限： 讀寫權(quán)限：ALL PRIVILEGES 只讀權(quán)限：SELECT DDL權(quán)限：CREATE,DROP,ALTER,SHOW VIEW,CREATE VIEW DML權(quán)限：SELECT,INSERT,UPDATE,DELETE,SHOW VIEW

!@#$%^&* ()_ +-=