grant select succeeds, but wont let users select
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
Youu can create a synonym (read up on public and private synoyms to see the difference) or when you do the select, prefix the table/view name with the owner, i.e.
select * from "schema_name"."table_name";
In your case:
select * from sys.v$xatrans$;
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.
Click Here to Expand Forum to Full Width