grant select succeeds, but wont let users select
hi,
have logged on as sys done grant select on v$xatrans$ to public and commit
all succeeded.
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
help?