Ability to access connecting user information from an SQL Trigger, such as userid

  • Thread starter Thread starter beginetienne
  • Start date Start date
Status
Not open for further replies.
B

beginetienne

Guest
· When the SQL USER function is invoked from a trigger, you would like to have the function return the user that started the connected client. Currently, when the USER function is invoked from a trigger it returns the owner of the trigger. Alternatively, you would like to have a way to access the _Connect metadata table (VST) for the user executing a SQL statement with a trigger on it. Because SQL triggers run in the server process, there is currently no way to tell which client process executed the SQL statement that fired the trigger. If that determination could be made, the necessary information about the client connection is stored in the _Connect VST. · This enhancement would allow the development of a more lightweight audit capability than the built-in OpenEdge Auditing. · The desired functionality is available through OpenEdge auditing, but it has a steep learning curve compared to the amount of functionality that will actually be used, and it requires involvement of your DBAs to implement it.

Continue reading...
 
Status
Not open for further replies.
Back
Top