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

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. Received on Wed Jul 05 1995 - 00:00:00 CEST