达梦数据库监控(脚本)¶

模板ID: 10778 | 模板标识: LW_Template DM Script General

帮助说明¶

CREATE USER itimmonitor IDENTIFIED BY itimmonitor123;

grant select on DBA_CONSTRAINTS to itimmonitor;

grant select on DBA_DATA_FILES to itimmonitor;

grant select on DBA_FREE_SPACE to itimmonitor;

grant select on DBA_INDEXES to itimmonitor;

grant select on DBA_OBJECTS to itimmonitor;

grant select on DBA_TABLESPACES to itimmonitor;

grant select on DBA_TRIGGERS to itimmonitor;

grant select on DBA_USERS to itimmonitor;

grant select on V$ASMGROUP to itimmonitor;

grant select on V$MEM_POOL to itimmonitor;

grant select on V$RECOVER_STATUS to itimmonitor;

grant select on V$RLOG to itimmonitor;

grant select on V$SESSIONS to itimmonitor;

grant select on V$SESSION_SYS to itimmonitor;

grant select on V$SQL_STAT to itimmonitor;

grant select on DBA_CONSTRAINTS to itimmonitor;

grant select on V$WAIT_CLASS to itimmonitor;

grant select on V$SYSTEMINFO to itimmonitor;

grant select on V$SYSSTAT to itimmonitor;

grant select on V$LOCK to itimmonitor;

grant select on V$SYSTEM_EVENT to itimmonitor;

grant select on V$DM_ARCH_INI to itimmonitor;

grant select on V$EVENT_NAME to itimmonitor;

grant select on V$DATAFILE to itimmonitor;

grant select on V$RLOGFILE to itimmonitor;"