Home » SQL & PL/SQL » SQL & PL/SQL » package modified details (oracle 12c, unix)
package modified details [message #657318] Sun, 06 November 2016 01:28 Go to next message
pstanand
Messages: 133
Registered: February 2005
Location: Chennai,India
Senior Member
Hi
I would like to know the user who have modified the package.
But the oracle user name is common and everyone can use it.
The all_objects shows the last ddl along with owner name and the owner name is commom.
Even in user_source table I couldnt get the info. Is there any way that I can get the os name and user name who modified the code.
request your help to solve this.
appreciate your kind help and advance thanks

Report message to a moderator

Re: package modified details [message #657319 is a reply to message #657318] Sun, 06 November 2016 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Old AUDIT and schema trigger or new unified auditing.

Read Introduction to Auditing.

Report message to a moderator

Re: package modified details [message #657320 is a reply to message #657318] Sun, 06 November 2016 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 29 July 2016 18:27

@pstanand,

Don't forget to feedback, here and in your previous topics.

Report message to a moderator

Re: package modified details [message #657321 is a reply to message #657320] Sun, 06 November 2016 01:38 Go to previous messageGo to next message
pstanand
Messages: 133
Registered: February 2005
Location: Chennai,India
Senior Member
Thanks michael.we have set audit_trail parameter set to db.
now let me know how can we get the required info.

this forum and you people always provided the correct solution and have helped so many.
Looking for your kind help.

Thanks

Report message to a moderator

Re: package modified details [message #657322 is a reply to message #657321] Sun, 06 November 2016 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

After setting the parameter, you have to restart the instance and execute the AUDIT statements for the statements you want to follow, the result will be in the DBA_AUDIT_TRAIL view.

Please read the links I gave you.

Report message to a moderator

Re: package modified details [message #657326 is a reply to message #657322] Sun, 06 November 2016 02:19 Go to previous messageGo to next message
pstanand
Messages: 133
Registered: February 2005
Location: Chennai,India
Senior Member
Will I able to get the results from dba_audit_trail view for month old transactions done in the db

Report message to a moderator

Re: package modified details [message #657327 is a reply to message #657326] Sun, 06 November 2016 02:27 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From the time you started the audit and until you removed it.

[Updated on: Sun, 06 November 2016 02:27]

Report message to a moderator

Previous Topic: query needed without using only where clause
Next Topic: Conditional based default value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:42:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.