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>
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