This content has been marked as final. Show 1 reply
I do not know what country you are in but in many countries what you have stated: "multiple users with same userid/password" is a prima facia violation of the law.
My first instinct is to fix the above so that everyone MUST log in with their own userid and password. To simplify and further secure the system they could proxy to a single account that owns the access privileges.
You can find working demos here:
and syntax here:
Note in the demo how an AFTER LOGON trigger is used to create a CONTEXT. This trigger can personalize the CONTEXT by taking into account information that can be obtained with the SYS_CONTEXT function
such as OS_USER and IP_ADDRESS.