• 具有下列特征的 OVDB 用户:
— 默认表空间是 OV_DATA
— 默认的临时表空间是 TEMP
— 在 OV_DATA、OV_INDEX 和 TEMP 上有无限制的配额
— 连接和资源权限
CREATE USER OVDB
IDENTIFIED BY
DEFAULT TABLESPACE OV_DATA
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT AQ_ADMINISTRATOR_ROLE TO OVDB
/
GRANT AQ_USER_ROLE TO OVDB
/
GRANT CONNECT TO OVDB
/
GRANT CTXAPP TO OVDB
/
GRANT DBA TO OVDB
/
GRANT DELETE_CATALOG_ROLE TO OVDB
/
GRANT EXECUTE_CATALOG_ROLE TO OVDB
/
GRANT EXP_FULL_DATABASE TO OVDB
/
GRANT IMP_FULL_DATABASE TO OVDB
/
GRANT OEM_MONITOR TO OVDB
/
GRANT RESOURCE TO OVDB
/
GRANT SELECT_CATALOG_ROLE TO OVDB
/
GRANT TIMESERIES_DBA TO OVDB
/
GRANT TIMESERIES_DEVELOPER TO OVDB
/
GRANT WM_ADMIN_ROLE TO OVDB
/
GRANT ZBTOBJAUTH TO OVDB
/
GRANT ADMINISTER DATABASE TRIGGER TO OVDB
/
GRANT ADMINISTER RESOURCE MANAGER TO OVDB
/
GRANT ALTER ANY CLUSTER TO OVDB
/
GRANT ALTER ANY DIMENSION TO OVDB
/
GRANT ALTER ANY INDEX TO OVDB
/
GRANT ALTER ANY INDEXTYPE TO OVDB
/
GRANT ALTER ANY LIBRARY TO OVDB
/
GRANT ALTER ANY OUTLINE TO OVDB
/
GRANT ALTER ANY PROCEDURE TO OVDB
/
GRANT ALTER ANY ROLE TO OVDB
/
GRANT ALTER SESSION TO OVDB
/
GRANT CREATE ANY INDEX TO OVDB
/
GRANT CREATE PROCEDURE TO OVDB
/
GRANT CREATE ROLE TO OVDB
/
GRANT CREATE SESSION TO OVDB
/
GRANT CREATE TABLE TO OVDB
/
GRANT CREATE TRIGGER TO OVDB
/
GRANT CREATE VIEW TO OVDB
/
GRANT INSERT ANY TABLE TO OVDB
/
GRANT SELECT ANY SEQUENCE TO OVDB
/
GRANT SELECT ANY TABLE TO OVDB
/
GRANT UNLIMITED TABLESPACE TO OVDB
/