What privilege user needs to access v$ views in Oracle 9i?

From: Greg <gray_ora_at_yahoo.com>
Date: 12 Oct 2001 13:33:00 -0700
Message-ID: <cb5d7f15.0110121232.3878c856_at_posting.google.com>

I created user REG_USER

CREATE USER REG_USER IDENTIFIED BY password DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO REG_USER;
GRANT RESOURCE TO REG_USER; GRANT SELECT ANY TABLE TO REG_USER; in Oracle 8i privilege "SELECT ANY TABLE" was enough to access v$ views. What privilege user needs to access this views in Oracle 9i? Received on Fri Oct 12 2001 - 22:33:00 CEST

This message: [ Message body ]
Next message: Jacob Nordgren: "How do I order by some of the rows in a column. Not all."
Previous message: Thomas Kyte: "Re: Trigger does not work, Please Help"
Next in thread: Ron Gardiner: "Re: What privilege user needs to access v$ views in Oracle 9i?"
Reply: Ron Gardiner: "Re: What privilege user needs to access v$ views in Oracle 9i?"

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

Original text of this message