Capture Windows User Name while inserting data

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
ebincherian
Posts: 5
Joined: Wed 24 Oct 2018 15:51

Capture Windows User Name while inserting data

Post by ebincherian » Wed 02 Jan 2019 19:09

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.

Pinturiccio
Devart Team
Posts: 2314
Joined: Wed 02 Nov 2011 09:44

Re: Capture Windows User Name while inserting data

Post by Pinturiccio » Tue 08 Jan 2019 16:33

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.

Code: Select all

select sys_context( 'userenv', 'os_user' ) from dual
This command will return information about the Windows user, and you can use it in your triggers.

Post Reply