Re: help on file modified in orcle apps
- From: James Morrow <morrow.james@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 20 Mar 2009 11:28:05 -0500
I suppose it depends.
Assuming that the person logged in as "applmgr" through an SSH or
telnet session, there may be some evidence of that login (machine
name, IP address) in /var/adm/messages or a similar log file. Of
course, tying that login to the modification of the file will be
dificult (how long were they logged in before modifying the file?)
Assuming that the person used "su" or "sudo" to become "applmgr",
there may be a similar log indicating when they became applmgr. As in
the above scenario, tying that to the actual modification of the file
will be difficult.
If the person is logged in as another user and (through the file
permissions) had access to modify the file, you probably won't know.
Now, if you have some degree of OS-level auditing turned on, you'll
likely have better luck.
-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLC
morrow.james <at> gmail <dot> com
james.morrow <at> trioragroup <dot> com
On Fri, Mar 20, 2009 at 11:16 AM, dba.young young <dba.young@xxxxxxxxx> wrote:
> Hi All,
> I am working on oracle appp 11.5.10.2
>
> Some changes in the production environment.
>
> So , I would like to find out how to find out the user who has last modified
> the unix file.
>
> When I do ls -ltr , it will only give me name of the user who is the owner
> of the file. eg : applmgr
>
> Now I would like to find out who is the person/unix user who has made
> modifications to the file......I mean to say with which unix user has he
> logged in to make the changes that he had done.
>
> Is there any way to find it out.
>
>
> Regards,
> Young.
Other related posts:
