Can't query sys.dba_* views from stored procedure

Hi,

We want to use an app that verifies role-grant scripts generated by Oracle Designer to prevent having to drop an entire role and recreate it (which in some cases would take a lot of time and would cause an unability to work for over 100 users for quite some time). In order to do this I created a package which contains a procedure which queries the sys.dba_roles view. Whenever I compile this package I get:
PLS-00201: identifier 'SYS.DBA_ROLES' must be declared Strange, because I can query the view anyway from the same user which owns and compiles the package.
Is there anything I might be doing wrong (building a procedure which only queries the view, results in the same error-message) or is there a workaround for this?

Any help would be much appreciated.

Thanks in advance,

Stevan van der Werf Received on Thu Mar 28 2002 - 02:50:15 CST