Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create public view...

Re: Create public view...

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 09 Oct 2004 12:19:31 -0700
Message-ID: <1097349656.203165@yasure>


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)
Received on Sat Oct 09 2004 - 14:19:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US