Session Browser is requiring select access to “GV_$ROLLNAME” in Toad 2025 R3 and fails to show any results. “GV_$ROLLNAME” does not exist in the database. I tried with and without “Use RAC views” selected. The same error occurs in both situations.
Session Browser works fine in Toad 2025 R2.
Eric Hobbs
It's not really required, despite the message. Just grant the other stuff that the privileges dialog is asking for and you will be fine. I will remove that from the message.
Thanks for reporting it.
If you used the Session Browser in 2025R2 with the same user that now 2025R3 is complaining about, then likely the view that you need SELECT on is v_$session_blockers (and gv_$session_blockers for RAC)
select grants for v_$session_blockers and gv_$session_blockers resolved the issue. I no longer receive the error message about “GV_$ROLLNAME“ and session browser is working again for 2025 r3. thank you.