ORA-01933 error..

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 Wed Oct 30 1996 - 00:00:00 CST