Re: want to see code of stored procedure but without permission to execute it

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 28 Sep 2007 13:00:28 GMT
Message-ID: <46fcfaec$0$9022$426a74cc@news.free.fr>

Benny wrote:

> No, I'm afraid with 'grant debug on ... to ...' I still can not see
> the code of a procedure.
> Not even with 'debug any procedure'.

> Only with 'grant execute...' a user is able to see (Toad) the code of
> someone elses procedure.

So, this is with TOAD, the "detail" I asked about. With sqlplus, 'grant debug' does the trick.

Cheers

---

échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Fri Sep 28 2007 - 08:00:28 CDT