This content has been marked as final. Show 4 replies
CREATE a ROLE to AUTHORIZATION [dbo]
Create a Session level parameter that has the SCHEMA prefix and pass this variable to the SQL override.
If helpful, pls mark correct or helpful
Txs,,,but I dont think it is viable... It is Oracle BI Applications... hundreds of sessions.
create the sysnonym in xxx schema to the table exists in the main schema