1. connection as sysdba
  2. SQL> grant select any dictionary to user_name;