tKS David, that worked.
-----Original Message----- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 12:14 PM To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Subject: Re: Error in procedure with dba_users As SYS, grant select on DBA_USERS to SYSTEM. You're running a stored procedure which requires explict grants, the DBA Role that SYSTEM has is not sufficient. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 com.banilejas@code tel.net.do To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Error in procedure with dba_users 03/21/2002 09:33 AM Please respond to ORACLE-L Hi list, I have this procedure under the system user, and when try to create it I get an error CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT USERNAME ESQUEMA FROM SYS.DBA_USERS WHERE USERNAME IN ('RAMON', 'SCOTT'); BEGIN FOR E IN ESQUEMAS LOOP DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'); END LOOP; END; 3/8 PL/SQL: SQL Statement ignored 4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared 11/4 PL/SQL: Statement ignored 11/32 PLS-00364: loop index variable 'E' use is invalid SQL> Any help . TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).