OraFAQ Forum: Security » can i do audit just on one table?

Home » RDBMS Server » Security » can i do audit just on one table? (AIX 10G )

Wed, 10 December 2008 07:57

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

can i do audit just on one table?

thanks

Wed, 10 December 2008 08:53

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

Senior Member
Account Moderator

Yes.
Have a look at AUDIT statement in SQL Reference.

Regards
Michel

Tue, 13 January 2009 01:14

mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad

Junior Member

AUDIT TABLE <TABLE_NAME>;

Tue, 13 January 2009 01:48

Michel Cadot
Messages: 68417
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: Wed Mar 22 18:11:23 CDT 2023