|
|
|
|
|
|
| Author |
Message |
flying
*nix forums beginner
Joined: 19 Jul 2006
Posts: 1
|
 Posted: Wed Jul 19, 2006 6:46 am Post subject:
how can i know who drop the job
|
|
|
If a job is removed, how can a DBA know who did it and from which
client station? I have looked into the online log, but found no
evidence. the version of oracle is 9.2.0.2 |
|
| Back to top |
|
 |
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Wed Jul 19, 2006 1:02 pm Post subject:
Re: how can i know who drop the job
|
|
|
flying wrote:
| Quote: | If a job is removed, how can a DBA know who did it and from which
client station? I have looked into the online log, but found no
evidence. the version of oracle is 9.2.0.2
|
Only the job owner can remove the job, and nothing is tracked.
If you audit the connections of the job owner, you can may be find out
something.
You could of course write your own wrapper for dbms_job including audit
code and revoke access from dbms_job.
--
Sybrand Bakker
Senior Oracle DBA |
|
| Back to top |
|
|
Mark D Powell
*nix forums Guru
Joined: 23 Apr 2005
Posts: 701
|
| Posted: Wed Jul 19, 2006 1:29 pm Post subject:
Re: how can i know who drop the job
|
|
|
sybrandb wrote:
| Quote: | flying wrote:
If a job is removed, how can a DBA know who did it and from which
client station? I have looked into the online log, but found no
evidence. the version of oracle is 9.2.0.2
Only the job owner can remove the job, and nothing is tracked.
If you audit the connections of the job owner, you can may be find out
something.
You could of course write your own wrapper for dbms_job including audit
code and revoke access from dbms_job.
--
Sybrand Bakker
Senior Oracle DBA
|
flying, If this is an ongoing problem I would think that you might want
to use the builtin audit command on sys.job$.
Also check the permissions on the undocumented package dbms_ijob as I
do believe that any job can be purged via this package. This is the
package that actually does the work for dbms_jobs and should normally
not be called directly so only user SYS and the
import_full_database and export_full_database system privileges should
be able to access it.
HTH -- Mark D Powell -- |
|
| Back to top |
|
|
Mladen Gogala
*nix forums Guru
Joined: 11 Mar 2005
Posts: 948
|
| Posted: Wed Jul 19, 2006 2:30 pm Post subject:
Re: how can i know who drop the job
|
|
|
flying wrote:
| Quote: | If a job is removed, how can a DBA know who did it and from which
client station? I have looked into the online log, but found no
evidence. the version of oracle is 9.2.0.2
|
That's precisely what auditing is for. You should come up with a plan
of what do you want to audit, turn on auditing, configure auditing to
audit what you want and never look into DBA_AUDIT_TRAIL again.
--
Mladen Gogala
http://www.mgogala.com |
|
| Back to top |
|
|
Bib Endum
*nix forums beginner
Joined: 13 Jul 2006
Posts: 4
|
| Posted: Fri Jul 21, 2006 3:45 am Post subject:
Re: how can i know who drop the job
|
|
|
"flying" <gyflying@gmail.com> a écrit dans le message de news:
1153291611.377441.160030@i3g2000cwc.googlegroups.com...
| Quote: |
If a job is removed, how can a DBA know who did it and from which
client station? I have looked into the online log, but found no
evidence. the version of oracle is 9.2.0.2
If you really really need to know, and you are archiving logs, I think you |
could use log miner, provided you know approximately when the job was
dropped... |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 2:14 pm | All times are GMT
|
|
Remortgages | Loans | Loans | Loans | Xbox Mod Chip
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
