How to suppress database connection notifications

You can limit the number of notifications to those about connection requests made from Ranger to an Oracle db.

Ranger Admin performs many interactions with its backend database (often Oracle), for example; policy updates, user/group info updates, etc. A customer can see audit logs that represent all activities at the Oracle side, not just connection attempts.

To limit the number of notifications to those that describe persistent db connections:

  1. In Cloudera Manager Home, select Ranger, then choose Configuration.
  2. On Configuration, in Search, type log4j.
  3. In Ranger Admin Logging Advanced Configuration Snippet (Safety Valve)
  4. In Ranger Admin Default Group, type the following text:
    log4j.category.com.mchange=FATAL, sql_appender
    log4j.additivity.com.mchange=false
    Figure 1. Suppressing Ranger db connection notifications
    Suppressing Ranger db connection notifications
  5. Click Save Changes.

    After saving changes, the Stale Configuration icon appears on the Cloudera Manager UI. Optionally, click Stale Configuration to view details.

  6. Select Actions > Restart.