Prerequisites for Enabling Oracle Database Monitoring for BYOD

This section lists the prerequisites for enabling Oracle Database monitoring when using the BYOD option.

You must grant appropriate permissions to Oracle DB Exporter users before enabling Oracle Database monitoring. In a BYOR deployment, ensure that the database user used by Oracle DB Exporter to connect to the Oracle Database has the required privileges, based on the types of metrics being collected. The database users used by Oracle DB Exporter will need the following permissions:

Task	Permissions
To fetch built-in default metrics.	CREATE SESSION SELECT_CATALOG_ROLE
To run custom SQL queries against Siebel CRM table owner schema.	CREATE SESSION SELECT access on the Siebel table owner schema

To create database users and grant permissions, connect to Oracle Database using the database admin user and do the following:

Create a user account to fetch database metrics:
```
SQL> create user <metrics_user> identified by <password>;
```

Grant CREATE SESSION and SELECT_CATALOG_ROLE permissions to <metrics_user>:

SQL> grant 'SELECT_CATALOG_ROLE' to <metrics_user>;
SQL> grant CREATE SESSION to <metrics_user>;

Create a user to run custom queries:

SQL> create user <custom_query_user> identified by <password>;

Grant CREATE SESSION to <custom_query_user> created in step 3:
```
SQL> grant CREATE SESSION to <custom_query_user>;
```

Grant SELECT privileges on all Siebel CRM tables after the Siebel CRM database import completes; that is, after the import_siebel_db stage of Siebel CRM environment provisioning completes:

SQL> 
BEGIN
   For t IN (SELECT table_name FROM all_tables where owner = '<table_owner_user in UPPERCASE>') LOOP
      EXECUTE IMMEDIATE 'GRANT SELECT ON ' || '<table_owner_user in UPPERCASE>' || '.' || t.table_name || ' TO ' || '<custom_query_user>';
   END LOOP;
END;
/