tracing question
Date: Fri, 15 Jul 2016 12:35:06 +0000 (UTC)
Message-ID: <165450081.554393.1468586106927.JavaMail.yahoo_at_mail.yahoo.com>
Following up on Debra's question.. I'm wondering if it's possible to set tracing to list ONLY the user's commands issued, and not include all the internal parsing. I'm aware of the method of writing a trigger to record insert/update/delete statements into a table, but I also need to know what select statements the user is issuing. When setting tracing on in a session, there's a lot of internal information to get thru, and it isn't clear to me which are the user issued commands.
>>>
I’m working thru this issue with vendor software now. Theapplication installation requires a schema, and there are scripts to run topre-create the schema.. so it seems it should not be necessary to grant DBAprivileges. I’ve decided to put tracing/auditing on to see what the applicationuser is trying to do when it connects, and maybe this way, can grant just theprivileges needed instead of DBA. If anyone has done this before and is willing to share theirscripts, etc. please contact me? Or post URL Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 15 2016 - 14:35:06 CEST