Re: Stored procedures ignore grants

From: DavidJRoth <davidjroth_at_aol.com>
Date: 24 Dec 1994 12:08:18 -0500
Message-ID: <3dhki2$emc_at_newsbf02.news.aol.com>


.Subject: Re: Stored procedures ignore grants
.From: dvick_at_lanier.com (Don Vick)
.Date: Fri, 23 Dec 1994 16:57:40 GMT
.Message-ID: <D19wG5.D0J_at_lanier.com>

.In article <3dd294$e26_at_lll-winken.llnl.gov>,
.Jeff Busch <68a869_at_llnl.gov> wrote:
.>I have found that I cannot compile a stored procedure which selects from
.>another user's table if my grant on that table is role-based. I get an
.>error "Table or view does not exist". If I am given an individual grant

.>on the table, I have no problem.
.>
.I have encountered a similar "feature" in 7.0.16:

. create view dummy as select 'x',u.* from dual,dba_users u

                                            *
. ERROR at line 1:
. ORA-01933: cannot create a stored object using privileges from a role

.I don't know why this should be a problem, but it is clearly Oracle's
.intention to disallow this sort of thing.

.--------------------------------------------------------
.Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com)
.Voice: (404) 493-2194 Fax: (404) 493-2399

This really is a FEATURE. It is covered in all of the Oracle Classes. As near as I have been able to learn it was set up this way to limit the depth of the dependancy tree that needs to be checked when a procedure executes. Received on Sat Dec 24 1994 - 18:08:18 CET

Original text of this message