grant SELECT on the view directly to your user, or to PUBLIC
--
Andrew - Wizzard
barnetaj_at_bp.com
Olivier Bercovitz <oberco_at_club-internet.fr> wrote in article
<35118703.4317B428_at_club-internet.fr>...
> Hello everybody,
>
> on a database (V7.1.6) , connected as system, I try to do this :
>
> create or replace view temprpt_free as select tablespace_name,sum(bytes)
> free
> from sys.dba_Free_space
> group by tablespace_name;
>
> and I have the error : ORA-1933 : cannot create a stored object using
> privileges from a role
>
> What can I do ? which grant ? (I have dba role granted)
>
> Thank for your help (please don't send me the explanation of the error
> from the Messages Manual ! I read it :-) )
>
> Olivier
>
>
Received on Thu Mar 19 1998 - 00:00:00 CST
