TOAD Grand Error on Oracle Database

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"

Solution :

  1. 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.

That’s all.

Hits: 1

Leave a Reply

Your email address will not be published. Required fields are marked *