See what security is used by a session
I want to "reverse-engineer" the security of my application (Oracle forms), i.e. I want to know what database object security is needed for every module of my application. Some explanation: one module corresponds to one database session. A module is identified by it's name, which is visible in the "module"-field of the corresponding v$session-record. Also, I could change the application in that way that f.i. the "sessionid" (= userenv('SESSIONID')) is logged toghether with the module name everytime the module is started. So I have my links between sessions and modules.
To link the necessary security, I need to know what DML each module (= session) is performing. Seems simple, but I can't find the good way. These are my closest guesses: