OraFAQ Forum: Server Administration » table have been update/modify in oracle 9

Home » RDBMS Server » Server Administration » table have been update/modify in oracle 9 (oracle 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table have been update/modify in oracle 9 [message #468366]

Thu, 29 July 2010 21:36

chuikingman
Messages: 90
Registered: August 2009

Member

Hi,
I use oracle 9i.
After doing execution ,process, how can I know which table in the oracle have been update/modify ??
Please advice how to check it out ???

Thank

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468367 is a reply to message #468366]

Thu, 29 July 2010 21:42

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Audit :- Auditing Database Use

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468369 is a reply to message #468367]

Thu, 29 July 2010 22:01

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Following will give you Example of Auditing in Oracle 10g Release 2

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468370 is a reply to message #468369]

Thu, 29 July 2010 22:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please advice how to check it out ???
DBMS_LOGMNR

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468372 is a reply to message #468370]

Thu, 29 July 2010 22:32

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Example of DBMS_LOGMNR

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468373 is a reply to message #468367]

Thu, 29 July 2010 22:42

chuikingman
Messages: 90
Registered: August 2009

Member

Hi,
I set audit_trail=DB in initXXX.ora file .
and restart the db .
But there is no auit file come out ???
Why

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468374 is a reply to message #468370]

Thu, 29 July 2010 22:45

chuikingman
Messages: 90
Registered: August 2009

Member

any other way apart from DBMS log manager ???

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468375 is a reply to message #468369]

Thu, 29 July 2010 22:45

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

rahulvb wrote on Thu, 29 July 2010 22:01

Following will give you Example of Auditing in Oracle 10g Release 2

Did you Read?

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468376 is a reply to message #468374]

Thu, 29 July 2010 22:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But there is no auit file come out ???
>Why
the audit data goes to DB where you specified & not to OS file

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468377 is a reply to message #468376]

Thu, 29 July 2010 22:49

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

SELECT view_name
FROM   dba_views
WHERE  view_name LIKE 'DBA%AUDIT%'
ORDER BY view_name;

VIEW_NAME
------------------------------
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT
DBA_AUDIT_POLICIES
DBA_AUDIT_POLICY_COLUMNS
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_COMMON_AUDIT_TRAIL
DBA_FGA_AUDIT_TRAIL
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_REPAUDIT_ATTRIBUTE
DBA_REPAUDIT_COLUMN
DBA_STMT_AUDIT_OPTS

14 rows selected.

Elapsed: 00:00:00.57

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468423 is a reply to message #468377]

Fri, 30 July 2010 01:28

chuikingman
Messages: 90
Registered: August 2009

Member

Hi,
I select from above table/view .
But no row can be find ...
Why ???

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468427 is a reply to message #468423]

Fri, 30 July 2010 01:32

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

chuikingman One Question did you read the links WE have give you?

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468439 is a reply to message #468427]

Fri, 30 July 2010 01:52

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Answer: No. Wink

Regards
Michel

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468440 is a reply to message #468427]

Fri, 30 July 2010 01:55

chuikingman
Messages: 90
Registered: August 2009

Member

yes . but no work

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468443 is a reply to message #468440]

Fri, 30 July 2010 02:01

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So, read it again.

Audit must be activated BEFORE you want to search something.

Regards
Michel

[Updated on: Fri, 30 July 2010 02:01]

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468480 is a reply to message #468443]

Fri, 30 July 2010 03:53

chuikingman
Messages: 90
Registered: August 2009

Member

I use below command to enable audit.

AUDIT ALL BY ACCESS;
AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY fireid BY ACCESS;
AUDIT EXECUTE PROCEDURE BY ACCESS;

AUDIT INSERT, UPDATE, DELETE ON sys.aud$ BY ACCESS;

but I check the dba_audit_trail .

I think the process is do delete something in the table .
But I check dba_audit_trail .... there is nothing update ///
why ?????no new row find in the dab_audit_trail table ....
any advice .....

[Updated on: Fri, 30 July 2010 03:54]

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468481 is a reply to message #468480]

Fri, 30 July 2010 04:01

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you set AUDIT_TRAIL parameter to DB?
Did you restart the database after that?

Regards
Michel

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468498 is a reply to message #468481]

Fri, 30 July 2010 05:17

chuikingman
Messages: 90
Registered: August 2009

Member

yes.
I alredy set audit)trail to DB.
Restart the database .....

Why the process do delete something in the table .
but in the dba_audit_trail cannnot find this update ????
what is wrong for below command ???

AUDIT ALL BY ACCESS;
AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY fireid BY ACCESS;
AUDIT EXECUTE PROCEDURE BY ACCESS;

AUDIT INSERT, UPDATE, DELETE ON sys.aud$ BY ACCESS;

anything wrong ????it is suppose to open all the udit for all the process access the db........

Report message to a moderator

Re: table have been update/modify in oracle 9 [message #468529 is a reply to message #468498]

Fri, 30 July 2010 10:08

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I do not trust you did this as if you really executed what you posted no one but SYS can do something.

Post evidence: copy and paste all your SQL*Plus sessions. Give the full Oracle version.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Fri, 30 July 2010 10:08]

Report message to a moderator

Previous Topic:	ASM Separation
Next Topic:	How to know currently running databases in single server ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 02:56:29 CDT 2024