Audit Trail

Read each change to the security settings and critical data of Scops, also the changes made directly in the repository.

Settings, Audit Trail for the last 30 days, with the filter bar, By table and six rows
An orange dot marks a change from outside Scops. A red dot marks a refused attempt.

Before you begin

  • You need View Audit Trail. With only this permission, an auditor can read the trail and change nothing.
  • The repository account needs CREATE TRIGGER. Without it, Scops records nothing, and the page shows the missing grant.

Read the trail

  1. Open Settings › Audit Trail.

  2. Set the filters below, then click Filter.

  3. Click a row. The panel shows the values before and after, the statement of a schema change or a refused attempt, and the session.

An audit row: an update to SETTINGS by SYSTEM from SQL Developer, made outside Scops
FilterWhat it doesDefault
Window24H to 1Y, or a date range.30D
WhoOutside Scops (other sessions and refused attempts), Through Scops or Everyone.Outside Scops
Table, ChangeThe audited tables, and Insert, Update, Delete, Schema change or Refused.All
SearchA user, a machine, a row or a column.Empty

The list shows the newest 1,000 rows. A password never shows: a changed password shows as "Secret, fingerprint".

What is recorded

  • Users, roles, permissions, LDAP mappings and credentials.
  • Databases, groups, environments and owners.
  • Security, directory, mail, trap, AI and automation settings.
  • The queries of your alerts and reports, recipients, retention and license marks.
  • Each change card that a user applies or dismisses.
  • The log of Scops, when a session other than Scops changes it.

Scops refuses an attempt to change the trail, or to drop or empty an audited table, and records it as Refused.

Seals

Every five minutes, Scops seals the new rows with a key made from the key of the stored passwords. Each seal is chained to the one before it. Scops finds a sealed row that someone changed or removed, and puts back an audit trigger that someone disabled or dropped.

Scops writes each problem to the Audit category of Logs, and the page shows a red line. If this server does not have the key, Scops records rows but does not seal them.

Updated October 30, 2026