Home » RDBMS Server » Security » can i do audit just on one table? (AIX 10G )
can i do audit just on one table? [message #364913] Wed, 10 December 2008 07:57 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
can i do audit just on one table?

thanks
Re: can i do audit just on one table? [message #364932 is a reply to message #364913] Wed, 10 December 2008 08:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Have a look at AUDIT statement in SQL Reference.

Regards
Michel
Re: can i do audit just on one table? [message #380702 is a reply to message #364913] Tue, 13 January 2009 01:14 Go to previous messageGo to next message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
AUDIT TABLE <TABLE_NAME>;
Re: can i do audit just on one table? [message #380717 is a reply to message #380702] Tue, 13 January 2009 01:48 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> audit table t;
audit table t
            *
ERROR at line 1:
ORA-00933: SQL command not properly ended

It was not urgent to answer to 1 month old topic so please verify before replying.

Regards
Michel
Previous Topic: Row level security
Next Topic: Password transfer between Database Server and clients
Goto Forum:
  


Current Time: Thu Mar 28 05:33:44 CDT 2024