I recently received the following error while trying to connect to a database.
Error Message :
"Access to the following views required: V$SESSION, V$PROCESS, V$SESS_IO, V$SESSION_WAIT, V$SESSION_EVENT, V$ACCESS, V$SESSSTAT, V$STATNAME, V$OPEN_CURSOR, V$SQL, V$LOCK, V$SESSION_LONGOPS, SYS.V_$TRANSACTION, SYS.V_$ROLLNAME, V$SQLTEXT_WITH_NEWLINES"
- Open a Linux terminal and enter the SQL*Plus command:
sqlplus /as sysdba
SQL> Grant select any dictionary, select any table, select_catalog_role to db_user; Grant succeeded. SQL> grant execute on sys.dbms_workload_repository to db_user; Grant succeeded.