Re: Insufficient privileges error

From: Joe Mellors <joemellors_at_aol.com>
Date: 8 Feb 2002 16:11:55 -0800
Message-ID: <53566469.0202081611.2123c6a_at_posting.google.com>


> when PL-SQL code is executed, priviliges granted through roles
> is 'lost' and that only directly granted priviliges have effect.

Thanks for your help Jon. What you say would explain a lot. The only thing I'm wondering now is whether roles are disabled in all pl/sql blocks or just in some. I might do a couple of experiments at work next week to check this out !

Regards,

Joe Mellors Received on Sat Feb 09 2002 - 01:11:55 CET

Original text of this message