https://community.esri.com/t5/geodatabase-questions/report-user-role-changes-in-sql-db/m-p/1253771#M8220 <P>Hello All,</P><P>We are currently exporting and reporitng user role changes through excel spreadsheets.&nbsp; We would like to record these changes in the database into a table that is continuosly appending when new role changes occur.&nbsp; This is to improve our auditing efforts.</P><P>Has anyone done this or tried to implement something like this?&nbsp; What would be the best approach?&nbsp; Could we use python or ArcGIS API for python for this?</P><P>Any help will be greatly appreciated.</P><P>Thank you,</P><P>Amanda</P> Wed, 01 Feb 2023 13:30:46 GMT ABishop 2023-02-01T13:30:46Z https://community.esri.com/t5/geodatabase-questions/report-user-role-changes-in-sql-db/m-p/1253771#M8220 <P>Hello All,</P><P>We are currently exporting and reporitng user role changes through excel spreadsheets.&nbsp; We would like to record these changes in the database into a table that is continuosly appending when new role changes occur.&nbsp; This is to improve our auditing efforts.</P><P>Has anyone done this or tried to implement something like this?&nbsp; What would be the best approach?&nbsp; Could we use python or ArcGIS API for python for this?</P><P>Any help will be greatly appreciated.</P><P>Thank you,</P><P>Amanda</P> Wed, 01 Feb 2023 13:30:46 GMT https://community.esri.com/t5/geodatabase-questions/report-user-role-changes-in-sql-db/m-p/1253771#M8220 ABishop 2023-02-01T13:30:46Z https://community.esri.com/t5/geodatabase-questions/report-user-role-changes-in-sql-db/m-p/1253894#M8222 <P>You might be able to achieve that via the RDBMS native Audit buil-in functionality.</P><P><A href="https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver16" target="_blank" rel="noopener">SQL Server Audit (Database Engine) - SQL Server | Microsoft Learn</A><BR /><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/introduction-to-auditing.html" target="_blank" rel="noopener">Oracle - Introduction to Auditing (oracle.com)</A><BR /><A href="https://www.pgaudit.org/" target="_blank">PostgreSQL Auditing Extension | PGAudit</A></P><P>You will need to contact your RDBMS Administrator to further assistance with Database Audit.</P> Wed, 01 Feb 2023 16:07:49 GMT https://community.esri.com/t5/geodatabase-questions/report-user-role-changes-in-sql-db/m-p/1253894#M8222 MarceloMarques 2023-02-01T16:07:49Z