Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored Procedures AC?
Tobias Svennebring wrote:
>
> Hi
>
> I wonder if there is a way to control who has access to my Stored Procedures?
>
> Sincerely Tobias Svennebring
I'm assuming that you mean execute access as opposed to creation etc.
You can set at a database level on a per user basis you can execute
particular SPLS. You could always use ROLES (see some of the earlier
discussion about security) If you can be bothered you could even code
it into the SPL but you'd have to be very sad and lonely;-))
-- Paul Watson # WF Software Ltd # It said run using Windows 95 Tel: +44 1436 674629 # or better in the manual Fax: +44 1436 678693 # so I used Unix www.wfsoftware.co.uk #Received on Tue Feb 17 1998 - 00:00:00 CST