Accessing v$sess_io and v$sqltext

From: <jwilkin_at_max.wosc.osshe.edu>
Date: 1995/07/05
Message-ID: <3tf1tk$1es_at_osshe.edu>#1/1

I need to be able to select from the v$ tables from a user other than sys. For most of them, this is not a problem. Select access has been granted to the proper user. But when I try to grant select access to v$sess_io or v$sqltext, I get ORA-02030: can only select from fixed tables/views.

Is there any way to access these tables from another user? I really don't want to use sys!

Thank you,

Jessica Wilkinson
Programmer/Analyst
Administrative Computing
Western Oregon State College
jwilkin_at_max.wosc.osshe.ed Received on Wed Jul 05 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Frenchy461: "Re: Accessing v$sess_io and v$sqltext"
Previous message: Anil Nair: "Procedure to copy long data from one table to another"
Next in thread: Frenchy461: "Re: Accessing v$sess_io and v$sqltext"
Reply: Frenchy461: "Re: Accessing v$sess_io and v$sqltext"
Reply: Gary Gapinski: "Re: Accessing v$sess_io and v$sqltext"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message