Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01933 error..
Grant select on the view directly to the user, instead of GRANT CREATE VIEW.
Richard
Jeff Murphy wrote:
>
> 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.
Received on Fri Nov 01 1996 - 00:00:00 CST