Re: Read-only proc privledges

"Mark Sisson" <mark_at_corporatedigital.com> wrote in message 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

that's about the size of it... why would you want a user to see code that they have no rights to execute? except as developer examples, which there are other ways to get...

other than for reference, can you provide a business function reason for allowing a user to read SP code?

++ mcs Received on Tue Oct 26 2004 - 20:07:04 CDT