Re: select_catalog_role does not let me see data dictionary . why?
From: joel garry <joel-garry_at_home.com>
Date: Tue, 22 Jun 2010 13:18:55 -0700 (PDT)
Message-ID: <fa748bab-5377-42f3-a492-49496c188678_at_y13g2000yqa.googlegroups.com>
On Jun 22, 12:19 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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.
Date: Tue, 22 Jun 2010 13:18:55 -0700 (PDT)
Message-ID: <fa748bab-5377-42f3-a492-49496c188678_at_y13g2000yqa.googlegroups.com>
On Jun 22, 12:19 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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.
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
-- _at_home.com is bogus. "They could just re-encode it.” http://www.signonsandiego.com/news/2010/jun/21/authorities-break-widespread-counterfeiting-ring/Received on Tue Jun 22 2010 - 15:18:55 CDT