Re: ORA-01933 error..

From: <vermaat_at_gemini.tfdl.agro.nl>
Date: 1996/11/05
Message-ID: <1996Nov5.152025.574@ns2>#1/1

In article <557rg0$jo_at_prometheus.acsu.buffalo.edu>, jcmurphy_at_acsu.buffalo.edu (Jeff Murphy) writes:
>i have a user (user1) that belongs to a role (role1). role1 has the
>privilege "CREATE VIEW".
>
>the user can do the following with no problem:
>
>create view test as select table_name, tablespace_name from all_tables;
>
>but can not to this:
>
>create view test as select item1, item2 from user2.item_list;
>
>where "user2.item_list" is a view into several of user2's tables.
>
>user1 has select perms on the views and tables of user2.
>
>here is the error message:
>
>ORA-01933: cannot create a stored object using privileges from a role
>
>the manuals indicate "grant the priv directly to the user" as the
>workaround. i tried granting "create view" directly.. but the same error
>occurs.

Instead, you should grant SELECT to this user on user2's tables directly and not through a role (which has been done according to the error message).

---

| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

---

| p.j.r.vermaat@fd.agro.nl | http://www.agro.nl/~vermaat/ |

---

|                           Flagellant in Dreamland                            |
********************************************************************************

Received on Tue Nov 05 1996 - 00:00:00 CST