after a bunch of mucking around i'm getting that in order for a user to be used as a client by a proxy user then that user must have the CREATE SESSION privilege assigned directly as opposed to through a role.
can anyone confirm that? can someone point to where this is documented in the oracle documentat because i can't find any reference to it.
our database target is 10g R2.
thanks in advance.