Very Computer

Hi Jaap,

A couple of points:

Point 1)

Oracle has bother to document this. A search in the Concepts manual
(which took me all of 38 seconds, I set timing on) found this in the
Introduction to Roles: "..roles are not meant to be used for application
developers, because the privileges to access schema objects within
stored programmatic constructs need to be granted directly".

Further on when discussing roles in the PL/SQL Blocks and Roles section,
there is a discussion on this very subject that describes it very
clearly. "All roles are disabled in any named PL/SQL block (stored
procedure, function or trigger) that executes with definer rights" is
one such quote.

It *IS* clearly and concisely documented in the first (and most obvious)
place I looked !!

Point 2)

It is posting etiquette to at least make some attempt to solve a problem
and search the google archives in case the question has been asked
before. This serves a dual purpose. Firstly, subscribers of the NG don't
have to download the same question again and again and perhaps more
importantly, the poster is very likely to find the answer more quickly
in the archives than waiting for an answer to arrive. A quick search on
this subject (roles procedure privileges) in google found 1,280 hits,
the first 50 of which (all I bothered to check) *all* had the answer to
this question.

Don't worry too much if you don't find my joke funny, few do :)

Cheers

Richard

Richard.Foote.vcf < 1K Download

On Sat, 10 Aug 2002 14:21:18 +1000, Richard Foote
...

Quote:

>Point 1)
...
>It *IS* clearly and concisely documented in the first (and most obvious)
>place I looked !!

...

>Don't worry too much if you don't find my joke funny, few do :)

...

Point 1): Silly me! I tried to find it in the PLSQL User's Guide and
Reference. Point taken.

Do you have proof of people not finding your jokes funny? I like them,
even in this thread, so don't be discouraged.

Jaap.

I volunteer as witness for the prosecution!

;-)
HJR

shucks and I thought it was the popular culture references you found
tiresome. Unless you are classifying Bowie as a joke :-(

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************