Printable View
I have this problem: - All users connect to database as user OD. And when one session has submited JOB, his Oracleuser=OD. But all sessions which have connected to database have ORacleUser=OD and I can not find - Who generated(submited) this JOB ??????
P.S. Sorry my bad English ! :)
Ask the user to send a email to you after he submits a job.
Tamil
You could ask.
Are your users using same username for OS log-in ? If not, you could look at OSUSER in V$SESSION. If they use same OS user also, its high time for you to consider security !!
Its time for you to implement role based user login access for the accountability. This will get you who is doing what.
Other wise follow Tamil. ;)