Can't select from SYS.DBA_USERS in a procedure

Hi folks,

I'm trying to select some values from the SYS.DBA_USERS table in a procedure but receive an error when trying to create the procedure: PLS-00201:identifier 'SYS.DBA_USERS' must be declared. It works fine with any other table but not with 'DBA_USERS'. I am executing this procedure as 'SYSTEM' and have full rights to all tables. What I'm ultimately trying to do is getting the username and password (encrypted) out of the DBA_USERS table for some 3rd party authentication application.

Any help would be appreciated.

Chris,
cermlich_at_swri.edu

CREATE OR REPLACE PROCEDURE XYZ.ITC_SM_AUTH(user_id VARCHAR2) IS
/* some variables here */

old_pw varchar2(30);
cid integer;
res integer;

BEGIN
/* some other work here */

 select password into old_pw from SYS.DBA_USERS where username=user_id2;

/* same statement works with any other table except SYS.DBA_USERS */
/* some other work here */

END; Received on Fri Feb 11 2000 - 14:36:09 CST