Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: URGENT: problems with grant excecute on a procedure

Re: URGENT: problems with grant excecute on a procedure

From: Alton Ayers <altona_at_ditw.com>
Date: Fri, 25 Jun 1999 12:52:24 -0400
Message-ID: <3773B3C8.7E2863CA@ditw.com>


You could also create a public synonym getdealer for vmp.getdealer

Kenneth C Stahl wrote:

> Even though vmp_user has the right to execute the pl/sql, it is still not in
> vmp_user's schema, so the correct line would be:
>
> SQL> exec :c :=vmp.getdealer(10000)
>
> Ken
>
> "M.Weiss" wrote:
>
> > I've got two users: vmp and vmp_user. vmp is admin, vmp_user is user and
> > is only allowed to acces, what vmp grants to him. Until now, everything
> > went fine, such as granting access to tables or so on.
> >
> > But now, when using procedures and functions the story begins:
> >
> > I grant the execute-rights to vmp_user by
> >
> > grant execute on getdealer to vmp_user;
> >
> > oky... but now, when calling the function, I get the following:
> >
> > SQL> var c refcursor
> > SQL> exec :c :=getdealer(10000)
> > begin :c :=getdealer(10000); end;
> >
> > *
> > ERROR in line 1:
> > ORA-06550: line 1, col 12:
> > PLS-00201: Identifier 'GETDEALER' must be declared
> > ORA-06550: line 1, col 7:
> > PL/SQL: Statement ignored
> >
> > Kann mir jemand dabei helfen ?
> >
> > Schon mal besten Dank.
> >
> > Marcus
Received on Fri Jun 25 1999 - 11:52:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US