Skip to content

Instantly share code, notes, and snippets.

@banterCZ

banterCZ/monitoring_user.sql

Created October 6, 2016 15:17
Show Gist options
  • Save banterCZ/d1bf570f8db428bcca8ae6a072644074 to your computer and use it in GitHub Desktop.
Save banterCZ/d1bf570f8db428bcca8ae6a072644074 to your computer and use it in GitHub Desktop.
Download ZIP
sqlplus / as sysdba
Raw
monitoring_user.sql
CREATE USER MONITORING IDENTIFIED BY password;
GRANT CREATE SESSION TO MONITORING;
GRANT SELECT any dictionary MONITORING;
GRANT SELECT ON V_$SYSSTAT TO MONITORING;
GRANT SELECT ON V_$INSTANCE TO MONITORING;
GRANT SELECT ON V_$LOG TO MONITORING;
GRANT SELECT ON SYS.DBA_DATA_FILES TO MONITORING;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO MONITORING;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment