ORACLE系统监控用户创建及权限分配

CREATE USER SYSMON
  IDENTIFIED BY pass$word
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 2 System Privileges for SYSMON 
  GRANT CREATE SESSION TO SYSMON;
  GRANT SELECT ANY DICTIONARY TO SYSMON;
  -- 1 Tablespace Quota for SYSMON 
  ALTER USER SYSMON QUOTA UNLIMITED ON USERS;