Cursor problem

                                   Hi

I have package there is declared 2 cursors: PACKAGE BODY xxx AS
...

CURSOR curUser (cUserName CHAR) IS
  SELECT user_id FROM sys.dba_users WHERE username=cUserName; CURSOR curUsrRights (cGrantee CHAR) IS

    SELECT granted_role FROM sys.dba_role_privs WHERE grantee=cGrantee; PROCEDURE ...
...

END;
When I try compile this, I get 2 error messages: PLS-00201: identifier 'SYS.DBA_USERS' must be declared PLS-00201: identifier 'SYS.DBA_ROLE_PRIVS' must be declared I get the same message when I try to use next query in some procedure SELECT user_id INTO nID FROM sys.dba_users WHERE ... What I do wrong?

The Synonyms 'DBA_USER' and 'DBA_ROLE_PRIVS' has been created in schema 'SYS'. I'm using Personal Oracle 7.3.3.

Regards, Erkki Arus
e-mail: erkki_at_spin.ee
ICQ: 53259421 Received on Wed Feb 09 2000 - 07:21:04 CST