Privilege problem with procedure

From: <kshave_at_health.gov.mb.ca>
Date: Wed, 17 Feb 1999 15:05:35 GMT
Message-ID: <7aelro$30e$1@nnrp1.dejanews.com>

I've created a procedure that queries dba_tab_privs and dba_objects. I initially created it as SYS and it runs fine. However, when I try to create it as anybody else (with SELECT access on the two views as well as synonyms set up) I get errors.

CREATE OR REPLACE PROCEDURE secrep AS

CURSOR user_curs IS
SELECT DISTINCT grantee FROM dba_tab_privs;

BEGIN
null;
END;
/

3/8      PLS-00341: declaration of cursor 'USER_CURS' is incomplete or
         malformed

What rights does one need to access the sys.dba_tab_privs and sys.dba_object views within a procedure?

-Keith

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 09:05:35 CST