Kbase P62238: Why does the USER() function in SQL-92 return 'PUB' when use
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2004 |
|
Status: Unverified
GOAL:
Why does the USER() function in SQL-92 return 'PUB' when used in a trigger?
FIX:
The USER() function returns 'PUB' when used in a trigger because SQL-92 executes triggers on the server instead of the client. When the server process invokes the USER() function the correct value of 'PUB' is returned.