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

Home -> Community -> Usenet -> c.d.o.server -> Re: ROLE ?

Re: ROLE ?

From: RP DATA SOLUTIONS <rpdata_at_cyberus.ca>
Date: Tue, 11 Aug 1998 22:00:04 GMT
Message-ID: <35d0bdf7.198287682@news.cyberus.ca>


The user executing the procedure must be granted the privs directly and NOT through a role....
"Dimon V. Karpov" <dvk_at_dcn-asu.ru> wrote:

>Hi, all!
>
>Oracle 7.3.3 for Sun Solaris 2.5.1
>
>I am give privilege : grant execute on my_procedure to other_user,
>but other_user, can not use 'my.my_procedure' in own procedure.
>Tell me please, where take the patch???
>

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************


Received on Tue Aug 11 1998 - 17:00:04 CDT

Original text of this message

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