Re: Stored procedures ignore grants

From: Don Vick <dvick_at_lanier.com>
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 Received on Fri Dec 23 1994 - 17:57:40 CET