Did you grant select access through a role, or directly to the user? In
this case, I believe you'll need to grant directly to the user and not
via a role. And when you say you have synonyms set up, I presume you
mean such that you don't need to prefix the view names with sys. ?
> -----Original Message-----
> From: kshave_at_health.gov.mb.ca [SMTP:kshave_at_health.gov.mb.ca]
> Posted At: Wednesday, February 17, 1999 10:06 AM
> Posted To: comp.databases.oracle.server
> Conversation: Privilege problem with procedure
> Subject: Privilege problem with procedure
>
> 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 - 16:39:38 CST
