Re: Baffled by basics (can select from sqlplus but procedure pukes)

From: James Knowles <kaa_at_xmission.com>
Date: Wed, 16 Jun 1999 23:53:26 +0000
Message-ID: <376838F6.64CD811C@xmission.com>

Thomas Kyte wrote:
> roles are never enabled during the execution of a procedure.

Aha! Yes, this is the problem. I got everything to work after making the explicit grants. I thought that this was terribly strange, but I just now chanced across this in the Oracle8 PL/SQL Programming book. Reading the explanation on p280 clarifies the "why."

THANK YOU! james

--
It's coming... http://www.countdown9199.com Received on Wed Jun 16 1999 - 18:53:26 CDT

This message: [ Message body ]
Next message: david_h_thompson_at_my-deja.com: "Re: Restricting Inserts/Updates"
Previous message: dna111_at_my-deja.com: "Want to learn Oracle, Please help. In DC area."
In reply to: Thomas Kyte: "Re: Baffled by basics (can select from sqlplus but procedure pukes)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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