so I created a synonym for a table to validate if it works and it does. BUT I think that it is not the best solution. Do I have to create synosyms for every table when I use another user who is not owner of table??
Why did you create a synonym?
It's useless, when checking the "fully qualified name" checkbox OBIEE uses the schema.table_name syntax in all the queries, so not a problem if your connection pool uses a different user, it will just works.
Get rid of the synonym, do not start having weird things like that in your database or you will end up with a messy DB you will not manage to keep clean and with errors because using the wrong object at some point.
Just to know: what is your DB? Oracle but which version?
Silly question, did you confirm that the db you are connecting to, using sqlplus and the one in the admin tool connection pool are the same?
Thank you Gianni Ceresa.
I created a new RPD and checked the "fully qualified name" checkbox and finally it works perfectly without synonyms.
FYI, my db source is Oracle 11g (184.108.40.206).
THANK YOU!! USEFUL SUPPORT.