Hi Dapi,

Sorry about the delay in responding....

The problem seems to lie with the B.PUB table, if I attempt any sort of select including a count(*) I get the same error. but only if I run the queries as user A

This is a straight forward SQL*Plus query and all the grants are direct.

Regards