Using the Database Module
To use the database module, perform the following steps:
- Go to the RN-150 Dashboard and locate the Additional Credentials page at the bottom of the list.
- From the Credential Type dropdown menu, select database .
- Enter the connection information for your first database server, and select Add .
- Enter the server’s IP, and select test . If the test is unsuccessful, select cancel to verify that the credentials were added correctly and retry.
- Enter and test connection information for each individual database server you would like to have analyzed. Oracle cluster database users should enter each server in a cluster separately and provide a direct connection to each server.
Account Permissions
The Database Module requires the following permissions:
| Database Type | Permission |
|---|---|
| MySQL | The account provided must have SHOW DATABASES and SHOW PROCESS privileges. It also requires select privileges on *.* |
| MS SQL Server | The account provided must have VIEW SERVER STATE, VIEW DATABASE STATE, and VIEW ANY DATABASE permissions. |
| Oracle Database | The account provided must have select privileges on V$INSTANCE and V$SESSION as well as on the following DBA tables : DBA_USERS, DBA_TABLES, DBA_INDEXES, DBA_OBJECTS, DBA_SEGMENTS, and DBA_LOBS. |