| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01933 error..
On 30 Oct 1996 15:16:16 GMT, jcmurphy_at_acsu.buffalo.edu (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
>
User1 needs to have select granted directly to him on user2.item_list.
eg:
grant select on user2.item_list to user1;
Then user1 can create a stored object since he won't be using priveleges from a role. User1 must have select on user2.item_list via 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.
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
 |
 |