Thanks to you both.

As we speak the dba is creating a role and applying the relevant permissions to views and tables.

Lee

Thanks Philip,

Excellent worked a treat , figured there must have be some way of resolving the SIDs.

I guess this is the only way...