Report User Role Changes in SQL DB

[ABishop]

Hello All,

We are currently exporting and reporitng user role changes through excel spreadsheets.  We would like to record these changes in the database into a table that is continuosly appending when new role changes occur.  This is to improve our auditing efforts.

Has anyone done this or tried to implement something like this?  What would be the best approach?  Could we use python or ArcGIS API for python for this?

Any help will be greatly appreciated.

Thank you,

Amanda

[MarceloMarques]

You might be able to achieve that via the RDBMS native Audit buil-in functionality.

SQL Server Audit (Database Engine) - SQL Server | Microsoft Learn
Oracle - Introduction to Auditing (oracle.com)
PostgreSQL Auditing Extension | PGAudit

You will need to contact your RDBMS Administrator to further assistance with Database Audit.