Hi RAAJ,


When you give DROP privs, user will automatically get this TRUNCATE.
TRUNCATE is not a separate Privs.

Thanks & Regards,
Rajesh Kumar Mathur,
Techmahindra Ltd.
Sharda Center
Pune - 04

-----Original Message-----
From: Thiyagaraj
[mailto:oracledba-ezmlmshield-x6803753.[Email address protected]
Sent: Thursday, August 31, 2006 2:48 PM
To: LazyDBA Discussion
Subject: TRUNCATE AUDITING

Hi all,
When i enable auditing for "TRUNCATE" iam getting error
message.And also i didn't find "TRUNCATE" in this query result also.
query is:
SQL> select * from system_privilege_map;This query will list out all the
privileges that can be enabled for auditing.Is this TRUNCATE will come
under privileges auditingor statement auditing or object level
auditing?Please share your experience ASAP.Thanks
Raaj


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page