can anyone tell me how to get a login id as part of a table reference

[brian_matthewsbrian matthews]

Hi all,

can anyone tell me how to get a loginid as part of a table reference,

If the database ref in the pdl is scott/tiger owner scott, how do I get a 
table owned by e.g. userid bmw into a cursor ref like that below,

declare mdat cursor for select count(*) as mycount from cust_orders a, 
?????.cust_orders b ...

where in this case ?????.cust_orders is bmw.cust_orders , and would vary to 
each users local tablespace where the owner is the loginid.

many thanks in advance, regards Bri,

_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger 
http://www.msn.co.uk/messenger