hi pando,

yes, my db does implement both FGAC and Parallel Execution (PX) and everything works just fine.

with PX, i believe the user's original slave process now takes on the role of a parallel coordinator, dividing up tasks into smaller units that will be taken on by parallel processes. since, these parallel processes are coordinated by the user's original slave process, and are not themselves individual 'free' processes, they will inherently have no more global of a 'scope' than the parallel coordinator; i.e. the parallel processes will inherit the FGAC predicates that were tacked on the original SQL statement.

and don't worry about the PL/SQL thingie...i'm sure you'll get the hang of it.

nick