Re: What privilege user needs to access v$ views in Oracle 9i?
From: Ron Gardiner <rggardin_at_planet.eon.net>
Date: Thu, 18 Oct 2001 02:37:06 GMT
Message-ID: <mfrz7.8204$%K4.1494325_at_news1.telusplanet.net>
Date: Thu, 18 Oct 2001 02:37:06 GMT
Message-ID: <mfrz7.8204$%K4.1494325_at_news1.telusplanet.net>
Greg,
Actually, in 8i "SELECT ANY TABLE" would not allow the v$ views unless the parameter O7_DICTIONARY_ACCESSIBILITY=TRUE (this is TRUE by default)
Regardless, you should be able to give them the proper access by granting the "SELECT_CATALOG_ROLE"
Hope this helps, it may be done differently in 9i, I can't help you there.
--- "Greg" <gray_ora_at_yahoo.com> wrote in message news:cb5d7f15.0110121232.3878c856_at_posting.google.com...Received on Thu Oct 18 2001 - 04:37:06 CEST
> 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?