Re: Refering to tables outside your schema - HELP!!!

From: Don Smith <eddas_at_huber.com>
Date: 1995/07/06
Message-ID: <3thecs$hv3_at_muddy.huber.com>#1/1


In article <3tet9c$8fe_at_shark.sb.grci.com>, Walter Marek <wmarek_at_grci.com> writes:
|> Frans & Margot <fmeeren_at_iaehv.nl> wrote:
|> >walter marek <wmarek_at_grci.com> wrote:
|> >>
|> >> Does anyone know where this is documented in the Oracle documentation?
|> >>
|> >> Walt
|> >> wmarek_at_grci.com
|> >>
|> >>
|> >Hi,
|> >
|> > ORACLE 7 Server Concepts Manual
|> > Chapter 18: Privileges and Roles
|> > Paragraph : DDL Statements and Roles
|> >
|> >Bye,
|> > Margot
|> >
|> Margot,
|>
|> The above para refers to executing DDL statements using SYSTEM privileges
|> granted through roles. I am refering to the fact that stored procedures
|> ignore DML statements using OBJECT privileges granted through roles.
|>
|> -- begin rant --
|> I suppose it is possible that if they had a crystal ball, someone like
|> Tom Kyte would be able to figure it out just from the concepts manual.
|> I am not saying that I have every manual memorized, but I have read most
|> of them and searched the on-line documentation CD and nowhere, that I
|> have found, does it explicitely say that stored procedures ignore
|> OBJECT privileges granted through roles.
|> -- end rant --
|>
|> Walt
|> wmarek_at_grci.com
|>
|> P.S. Margot, please do not take this as a personal attack against
|> yourself. I thank you for trying to help. If you or anyone can cite an
|> example of what I am looking for, I would like to hear about it.
|>

I'm certainly not trying to defend Oracle's documentation. I get pretty frustrated with it sometimes, myself. But look at Application Developer's Guide Chapter 7, section Privileges Required to Create Procedures and Packages (page 7-10, at least in my copy). There is a bulleted item which says that the owner of a procedure . . . blah blah blah . . . and ends with "the owner cannot have obtained required privileges through roles."

I don't know if I've seen it anywhere else, but I know I found it out for myself long before reading it in this book. How would I have known where to look? Oops, now I'm on the verge of ranting. Don't get me started.

-- 
-- 
============================================================
Donald A. Smith         Just another of the many Don Smiths
eddas_at_huber.com                  on the net               
Received on Thu Jul 06 1995 - 00:00:00 CEST

Original text of this message