cant query v$reserved_words after revoking SELECT ANY DICTIONARY and again granting
To test privileges on dba_ and v$ views, I revoked SELECT ANY DICTIONARY from a user. Then to replace v$reserved_words, I ran following: GRANT select on v_$reserved_words to userA; create or replace synonym userA_Schema.v_$reserved_words for sys.v_$reserved_words; Now I gave back SELECT ANY DICTIONARY to userA but I am still not able to access v$reserved_words. Not sure whats wrong here. Has anybody seen this?