fine grain access control + partitioned table

Hi,

Our system is 8.1.6.3 on Solaris 2.7.
We came across this pecularity:

A policy is placed on a partitioned table; the predicate returned is 1=1 or 2=1 (to simplify discussion).
If I perform this query:

   select count(*) from table_x partition (part_1) ;

the explain plan shows that all partitions are scanned. The execution took a long time. The concern is that if I truncate a partition, it may truncate the whole table!!

Have anybody come across this ?

TIA,
Ghee Received on Mon Jan 21 2002 - 05:25:39 CST