User accounts

User accounts
Prev	Installation	Next

Oracle account configuration

The Oracle user account used by Insider to collect Oracle statistics must be able to access Oracle dictionary in read-only mode. Use the following script to create Oracle user:

CREATE USER myusername IDENTIFIED BY mypassword; (specify tablespaces and other options if required)
GRANT CREATE SESSION TO myusername;
GRANT SELECT_CATALOG_ROLE TO myusername; (alternatively you can grant SELECT ANY DICTIONARY)

Some requirements are optional and are only necessary if you need a specific functionality:

GRANT ALTER SYSTEM TO myusername; (if you need to be able to kill user sessions)
GRANT EXECUTE ON DBMS_SYSTEM TO myusername; (if you need to be able to start/stop trace in user sessions)
GRANT EXECUTE ON DBMS_PIPE TO myusername; (if you need to be able to send/receive user-defined alerts)
GRANT SYSDBA TO myusername; (if you need to connect to a physical standby in a DataGuard configuration or any database in a mounted state)

Operating system account configuration

The operating system user account used by Insider to collect statistics must satisfy the following requirements:

UNIX. Generally Insider is using vmstat command to collect operating system statistics. The user account therefore must be able to execute vmstat command on the target host; in some cases Insider can collect operating system information without using vmstat command but that is not guaranteed

Windows. No special user requirements. The user must be able to login to Windows operating system