Re: Accessing v$sess_io and v$sqltext
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/07/06
Message-ID: <3tgcaf$e2q_at_sulawesi.lerc.nasa.gov>#1/1
Date: 1995/07/06
Message-ID: <3tgcaf$e2q_at_sulawesi.lerc.nasa.gov>#1/1
This is off the top of my head, but try granting access to a role on the V_$ equivalent of each table. Check in catalog.sql and catproc.sql to see how the views are normally set up.
Those particular views are limited to DBA accounts for security reasons, which wou may judiciously override.
Regards,
Gary Received on Thu Jul 06 1995 - 00:00:00 CEST