select_catalog_role does not let me see data dictionary . why?
in [Oracle]
|
Prev: connect to external DB ( sqlserver ) via JDBC
Next: General SAN advice needed for 2TB 9.2.0.8 database on HP-UX
From: zigzagdna on 22 Jun 2010 15:19 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.
From: joel garry on 22 Jun 2010 16:18 On Jun 22, 12:19 pm, zigzagdna <zigzag...(a)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 -- @home.com is bogus. "They could just re-encode it. http://www.signonsandiego.com/news/2010/jun/21/authorities-break-widespread-counterfeiting-ring/
From: zigzagdna on 22 Jun 2010 16:37
On Jun 22, 4:18 pm, joel garry <joel-ga...(a)home.com> wrote: > On Jun 22, 12:19 pm, zigzagdna <zigzag...(a)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 > -- > @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 |