Re: select_catalog_role does not let me see data dictionary . why?

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Tue, 22 Jun 2010 13:37:58 -0700 (PDT)
Message-ID: <504ee11c-c1b2-4c23-a291-9d25e363d59e_at_d37g2000yqm.googlegroups.com>

On Jun 22, 4:18 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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-wide...

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 Received on Tue Jun 22 2010 - 15:37:58 CDT