have logged on as sys done grant select on v$xatrans$ to public and commit
then logged on as another user and did select * from v$xatrans$ and message table or view does not exist ???
do I have to do somethign else as it is a v$ view - like create a synonym for it or something then grant select on that?
I have done everything as per the literature for allowing oracle-xa support, but this is failing and they just tell you to grant select on it which I have done
There could be many cases
1. If it is a dictionary table or the table owned the sys then do
alter system set o7_dictionary_accessibility=true scope=spfile
startup force then issue select
NO NEED TO USER OWNER WITH OBJECT NAME.
2. if it is not any dictionary table then
use owner while using it with any select statement.