Re: Create public view...

Julien wrote:

> Hello all,
>
> I'd like to create views for all users, but the command : "create public
> view..." did not work, so the views I create with user "Internal" are only
> usable with this user.
>
> How can I (maybe with a GRANT) give access to those views to other users in
> my db ?
>
> Thx All !

There is value in educating oneself before attempting neurosurgery: Same goes for working with Oracle.

You had no business creating a user named Internal You had no business trying CREATE PUBLIC

Try: GRANT ALL TO PUBLIC ON <view_name>;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)