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: Stored Procedures AC?

Re: Stored Procedures AC?

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/02/16
Message-ID: <34E857A6.9F939915@ubs.com>#1/1

Tobias Svennebring wrote:
>
> Hi
>
> I wonder if there is a way to control who has access to my Stored Procedures?
>
> Sincerely Tobias Svennebring

A user must have the execute privilege to use your procedure . Either by having the execute any proceudre privilege(e.g. user sys/system) or
explicit granted
e.g. grant execute on my_proc to other_user;

rgds
eugen Received on Mon Feb 16 1998 - 00:00:00 CST

Original text of this message

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