Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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)Received on Sat Oct 09 2004 - 14:19:31 CDT
![]() |
![]() |