Using the Database Module
To use the database module, perform the following steps:
To use the Database Module:
| 1. | Go to the RN-150 Dashboard and locate the Additional Credentials page at the bottom of the list. |
| 2. | From the Credential Type dropdown menu, select database. |
| 3. | Enter the connection information for your first database server, and select Add. |
| 4. | 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. |
| 5. | 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. |