AUDITING SQL: Changes in permissions

If you enable object monitoring within the RockSolid monitoring profile, by default all object permission changes (grant, revoke, deny) to objects will be logged as events within RockSolid.  This excludes temporary objects.

Viewing Object Permission Changes

To view object permission change history in RockSolid, please go to the Events -> Search Event History page.  From this page select the relevant date range, and instance details as required.

Using the event type option please select:

  • Audit SQL - Database Permission Changed : An event logged by RockSolid when a permission change occurs

Hitting Search will return relevant modification records.  Each event shows the object, permission type, date/time and user making the modification.

Have more questions? Submit a request


Please sign in to leave a comment.