0

I'm connecting to Oracle 19c as HR user. I want to execute the following SQL and some dba_... views:

select s.sid
      ,s.serial#
      ,s.username
      ,s.machine
      ,s.status
      ,s.lockwait
      ,t.used_ublk
      ,t.used_urec
      ,t.start_time
from v$transaction t
inner join v$session s on t.addr = s.taddr;

Oracle tells me the objects doesn't exist. It seems like a permission issue. What privileges are needed for me to access dynamic performance views and DBA_... views?

Joe W
  • 1,058
  • 9
  • 20
Just a learner
  • 2,082
  • 7
  • 36
  • 57

1 Answers1

2

If you want to allow that user to read all system views, you can use 

grant select_catalog_role to the_user;

Predefined Roles in an Oracle Database Installation