Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

command to find os user for inactive sid

Hi Guys,
There is any way to find out the OS user from the trace file information, if SID is not active.
0
nirvairghuman
Asked:
nirvairghuman
  • 2
1 Solution
 
sdstuberCommented:
no,  sorry

if the trace file doesn't have it and the sid is gone, then you can't track it
0
 
sdstuberCommented:
if you have auditing turned on, you might be able to derive it by looking in dba_audit_trail and checking timestamps of activities.

it's not 100% reliable, but it's better than nothing
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now