pat98's always & forever

EM 사용시 사용되는 SYSMAN 유저생성 및 권한 부여

=================================================

DROP USER SYSMAN CASCADE;

CREATE USER SYSMAN
  IDENTIFIED BY <password>
  DEFAULT TABLESPACE MGMT_TABLESPACE
  TEMPORARY TABLESPACE TEMP
  PROFILE MGMT_INTERNAL_USER_PROFILE
  ACCOUNT UNLOCK;
  -- 4 Roles for SYSMAN
  GRANT CONNECT TO SYSMAN;
  GRANT MGMT_USER TO SYSMAN WITH ADMIN OPTION;
  GRANT RESOURCE TO SYSMAN;
  GRANT SELECT_CATALOG_ROLE TO SYSMAN;
  ALTER USER SYSMAN DEFAULT ROLE ALL;
  -- 19 System Privileges for SYSMAN
  GRANT ALTER SESSION TO SYSMAN;
  GRANT ALTER USER TO SYSMAN;
  GRANT CREATE ANY SYNONYM TO SYSMAN;
  GRANT CREATE DATABASE LINK TO SYSMAN;
  BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
  PRIVILEGE    => SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
  GRANTEE      => 'SYSMAN',
  GRANT_OPTION => FALSE);
END;
/
  GRANT CREATE JOB TO SYSMAN;
  GRANT CREATE MATERIALIZED VIEW TO SYSMAN;
  GRANT CREATE PUBLIC SYNONYM TO SYSMAN;
  BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
  PRIVILEGE    => SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ,
  GRANTEE      => 'SYSMAN',
  GRANT_OPTION => FALSE);
END;
/
  BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
  PRIVILEGE    => SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
  GRANTEE      => 'SYSMAN',
  GRANT_OPTION => FALSE);
END;
/
  GRANT CREATE SESSION TO SYSMAN;
  GRANT CREATE TABLE TO SYSMAN;
  GRANT CREATE USER TO SYSMAN;
  GRANT CREATE VIEW TO SYSMAN;
  GRANT DROP ANY SYNONYM TO SYSMAN;
  GRANT DROP PUBLIC SYNONYM TO SYSMAN;
  GRANT DROP USER TO SYSMAN;
  GRANT MANAGE SCHEDULER TO SYSMAN;
  GRANT SELECT ANY DICTIONARY TO SYSMAN;
  -- 3 Tablespace Quotas for SYSMAN
  ALTER USER SYSMAN QUOTA UNLIMITED ON MGMT_AD4J_TS;
  ALTER USER SYSMAN QUOTA UNLIMITED ON MGMT_ECM_DEPOT_TS;
  ALTER USER SYSMAN QUOTA UNLIMITED ON MGMT_TABLESPACE;
  -- 48 Object Privileges for SYSMAN
    GRANT EXECUTE ON MGMT_VIEW.EM_COMPLIANCE_VIEW_USER TO SYSMAN;
    GRANT EXECUTE ON MGMT_VIEW.EM_METRIC_EVAL_VIEW_USER TO SYSMAN;
    GRANT DELETE, INSERT, SELECT, UPDATE ON SYS.AUX_STATS$ TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_APPLICATION_INFO TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_AQ TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_AQADM TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_AQ_BQVIEW TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_AUTO_TASK_ADMIN TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_CRYPTO TO SYSMAN WITH GRANT OPTION;
    GRANT EXECUTE ON SYS.DBMS_FEATURE_USAGE TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_JOB TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_LOB TO SYSMAN WITH GRANT OPTION;
    GRANT EXECUTE ON SYS.DBMS_LOCK TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_OBFUSCATION_TOOLKIT TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_OUTPUT TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_RANDOM TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_REDEFINITION TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_RLS TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SCHEDULER TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SESSION TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SHARED_POOL TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SNAPSHOT TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SPACE TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_SQL TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_STATS TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_TRANSACTION TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_TYPES TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_UTILITY TO SYSMAN;
    GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO SYSMAN;
    GRANT EXECUTE ON SYS.MGMT_PASS_VERIFY TO SYSMAN;
    GRANT SELECT ON SYS.OBJ$ TO SYSMAN;
    GRANT SELECT ON SYS.PROCEDURE$ TO SYSMAN;
    GRANT SELECT ON SYS.QT59150_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT59325_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT59731_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT59795_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT59837_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT59859_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT60485_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT60718_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT64134_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT71031_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.QT73997_BUFFER TO SYSMAN;
    GRANT SELECT ON SYS.USER$ TO SYSMAN;
    GRANT EXECUTE ON SYS.UTL_FILE TO SYSMAN;
    GRANT EXECUTE ON SYSMAN_RO.DERIVED_ASSOC_SANDBOX TO SYSMAN;
    GRANT EXECUTE ON SYSMAN_RO.EM_METRIC_EVAL_RO_USER TO SYSMAN;
    GRANT EXECUTE ON SYSMAN_RO.EM_RO_SANDBOX TO SYSMAN;