Subject: select_catalog_role does not let me see data dictionary

II am on Oracle 10.2 on HP UNIX 11i. My id has been assigned
select_catalog_role, yet I ger error when doing
Select * from dba_users
Select * from dba_tablespaces

I can access some v$ views but not all; e.g., I could not access v
$session. Is there some other privilege required in addition to
select_catalog_role to see data dictionary.

Thanks.

On Jun 22, 12:19*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:
try:
set role none;
set role all;
set role all excecpt select_catalog_role

and see if each of those make a difference. You can have a role
without it being enabled. Check login triggers and glogin.sql too.

jg
--
@home.com is bogus.
"They could just re-encode it.”
http://www.signonsandiego.com/news/2...rfeiting-ring/

On Jun 22, 4:18*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Joel:

Thanks so much, by setting
set role all

I was able to view all of data dictionary.

I never had to do this in the past on other databases. I am learning
something new.


Prem