"Julien" <machaon13_at_wanadoo.fr> wrote in message news:<ck682v$q2l$1_at_aphrodite.grec.isp.9tel.net>...
> 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 !
I'd encourage you to try it out ... you are looking for a GRANT ... TO
PUBLIC
Strongly encourage reading the docco to understyand the concepts of
USER, SCHEMA, ROLE and PUBLIC (which is not exactly the same as a
ROLE).
/Hans
Received on Fri Oct 08 2004 - 12:45:45 CDT
