Report User Role Changes in SQL DB

298
1
02-01-2023 05:30 AM
ABishop
MVP Regular Contributor

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

Amanda Bishop, GISP
0 Kudos
1 Reply
MarceloMarques
Esri Regular Contributor

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.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos