Devart Forums

Hi All,

Oracle Database 12c
Devart Excel Add-in Version : 1.8.868.0
Microsoft Excel 2016 MSO (16.0.9126.2295) 32-bit


We recently purchased devart license and our goal is enter to/modify data in database table. We setup devart connection to database and was able to select the table and view data. While inserting data into table, we need to have column which capture the windows user name of the user who inserted the data into table using devart. That way on looking at the data in database, we can figure out who inserted the records.

Please let me know if this is possible with devart.

Devart Excel Add-in for Oracle does not provide such functionality. You can create a trigger for each table that will update the needed column with required information. This command will return information about the Windows user, and you can use it in your triggers.