Re: problem by creating a view

Manser wrote:

> Hi oracle folks,
>
> I am running oracle 8.1.7 on an alphaserver 1000 with OpenVMS 7.3
>
> SQL> select tablespace_name,bytes from dba_data_files;
>
> TABLESPACE_NAME BYTES
> ------------------------------ ----------
> SYSTEM 209715200
> RMAN_TS 20971520
> RBS01 5242880
> USERS01 2097152
> TEMP01 2097152
> KLIMA 7340032
> KONTO 2097152
>
> 7 rows selected.
>
> SQL>
> SQL> create view tablespace_alloc
> 2 as select tablespace_name,bytes from dba_data_files;
> as select tablespace_name,bytes from dba_data_files
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> i don't understand ora-00942 , the table exists, see the query on top.
> can anyone tell me what's going on
>
> thanks for any help.

The privileges on the table must be granted expressly to the schema owner ... not through a role.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)