|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Track currenctly logged in user in trigger
Hi,
I want to set a specific field on every update to the username currently logged in. Is there something like 'now' for the username or so? At the moment, we already set a timestamp in the trigger, but want to include the username, too, to keep track of who made changes to which tables, etc. thanks for any help, Daniel Albuschat |
|
#2
|
||||
|
||||
|
you can use:
CURRENT_USER CURRENT_ROLE |
|
#3
|
|||
|
|||
|
Thanks, that was exactly what I was looking for.
cu, Daniel |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Track currenctly logged in user in trigger |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|