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.
Capture Windows User Name while inserting data
-
- Posts: 5
- Joined: Wed 24 Oct 2018 15:51
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Capture Windows User Name while inserting data
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.
Code: Select all
select sys_context( 'userenv', 'os_user' ) from dual