Is it possbile to add a username before tablename, e.g. foo.foobar

[UWesthaus]

Due to security issues I can only connect to the database using a restricted (viewer) account, which has only select rights on the tables, but no insert or update rights. To handle this the name of the account has to inserted before the table name within the sql:

• select * from foo.foobar

instead of

• select * from foobar

Is it possible to pass the account name as variable, e.g. like select * from :dbOwner.foobar? Or any other trick?