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: Read-only proc privledges

Re: Read-only proc privledges

From: brad.madison <Brad_IANAL_Madison_at_hotmail.com>
Date: Wed, 27 Oct 2004 01:54:25 GMT
Message-ID: <Xns958EC056FEBC6SunnySD@68.6.19.6>


mark_at_corporatedigital.com (Mark Sisson) wrote in news:88cc4eb9.0410261510.2775214e_at_posting.google.com:

> Hi all.
> I'm an old-school SQLServer DBA (don't throw any fruit please!) and
> now I'm working on a project with Oracle. I'm trying to use PL/SQL to
> view table structures, stored proc text, and view data in tables.
>
> Things are working fine accept that I'm unable to see any stored
> procedures. My DBA said that he couldn't create a login that just has
> stored proc view privledges without also giving my stored proc execute
> privledges. Which of course he doesn't want to do.
>
> So is there no way to give a user access to view stored procs with
> giving them execute rights?
>
> TIA
> mark

Stored procedures can be seen from DBA_SOURCE, IIRC. The DBA should be able to write a SP which can read and display the contents of this view & then GRANT you execute ONLY for this single SP.

HTH & YMMV Received on Tue Oct 26 2004 - 20:54:25 CDT

Original text of this message

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