Database Administration (MOSC)

MOSC Banner

cant query v$reserved_words after revoking SELECT ANY DICTIONARY and again granting

edited Nov 12, 2019 4:01AM in Database Administration (MOSC) 13 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center