Hello,

In Oracle 8.17 on Sun Solaris, could you please help me understand
Synonyms and Views at bit deeper. I know that if I want to create an
"interface" into multiple tables I can do it via a View. I have been
reading various materials and still do not grasp how to do this. If you
could please elaborate so even I can understand the syntax and steps. :-)

1. How can I create a View that ALL users that access my database
instance can perform SELECTs and INSERTs on?

2. How can I create a Synonym to the above View to be used by ALL users
that need access to the View?

Thanks,

Effie



Oracle LazyDBA home page