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: 120
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
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: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Old AUDIT and schema trigger or new unified auditing.

Read Introduction to Auditing.

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: 65389
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.

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: 120
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
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: 65389
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.

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: 120
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
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: 65389
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:
  


Current Time: Sat Feb 24 16:36:03 CST 2018

Total time taken to generate the page: 0.01443 seconds