안녕하세요.

Oracle 19c Multitenant DB의 PDB에서 Configuration 시 권한 오류가 나고 있습니다.

확인 부탁드립니다.

-접속 계정 : sys as sysdba

-로그

ORANGE_MONITORING_ROLE already exists.

Checking existence of User ORANGE

User Orange Already Exists

Changing Password for User ORANGE (Don't worry. There's no side-effect)

ALTER USER ORANGE DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

GRANT CONNECT, RESOURCE, CREATE TABLE, CREATE VIEW, CREATE ANY PROCEDURE TO ORANGE

GRANT SELECT ANY TABLE TO ORANGE WITH ADMIN OPTION

GRANT SELECT ANY DICTIONARY TO ORANGE WITH ADMIN OPTION

Publishing SysViews

CREATE OR REPLACE VIEW sys.oX$KTFBUE AS SELECT * FROM sys.X$KTFBUE

GRANT SELECT ON sys.oX$KTFBUE TO PUBLIC

GRANT SELECT ON sys.oX$KTFBUE TO ORANGE_MONITORING_ROLE

CREATE OR REPLACE VIEW sys.oX$BH AS SELECT * FROM sys.X$BH

GRANT SELECT ON sys.oX$BH TO PUBLIC

GRANT SELECT ON sys.oX$BH TO ORANGE_MONITORING_ROLE

SysViews created

Publishing SysPackages

GRANT EXECUTE ON sys.DBMS_SPACE_ADMIN TO PUBLIC

GRANT EXECUTE ON sys.DBMS_SPACE_ADMIN TO ORANGE_MONITORING_ROLE

GRANT EXECUTE ON sys.DBMS_SPACE TO PUBLIC

GRANT EXECUTE ON sys.DBMS_SPACE TO ORANGE_MONITORING_ROLE

GRANT EXECUTE ON sys.DBMS_SYSTEM TO PUBLIC

GRANT EXECUTE ON sys.DBMS_SYSTEM TO ORANGE_MONITORING_ROLE

SysPackages published.

  Creating table ORANGE_INVALID_ROWS

  Creating table ORANGE_EVENT_CLASS

  Creating table ORANGE_CHAINED_ROWS

  Creating table ORANGE_PLAN_TABLE

  Creating table ORANGE_PLSQL_LOCK_TABLE

  Creating table ORANGE_OPTION

Catalog TABLEs created.

  Creating View ORANGE_CLU_COLUMNS

 Error: # 1031, ORA-01031: 권한이 불충분합니다

감사합니다.