Database Security Products (MOSC)

MOSC Banner

See what security is used by a session

edited Oct 7, 2009 11:06PM in Database Security Products (MOSC) 5 comments
Hi,

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center