RE: Permission to see the procedures

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 11 Feb 2005 10:34:18 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C57@irvmbxw02>

> -----Original Message-----
> Kline.Michael
>
> The select_catalog_role doesn't seem to work. That made sense. Maybe
> that's why it didn't work.
 

By the way, what does this mean, "select_catalog_role doesn't seem to work". What Oracle errors are you getting?

SQL> select * from v$version ;
BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

SQL> create user a identified by a default tablespace users temporary tablespace temp ; Utilisateur créé.
SQL> grant create session to a ;
Autorisation de privilèges (GRANT) acceptée. SQL> grant select_catalog_role to a ;
Autorisation de privilèges (GRANT) acceptée.

SQL> connect a/a
Connecté.
SQL> select count (*) from dba_source ;
 COUNT(*)

---

   179172
SQL>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 11 2005 - 13:37:05 CST