RE: v$views

DROP command is to make sure that the synonym gets created even if you re-run the catalog.sql

and creating a PUBLIC synonym is a standard security procedure so the 'public' can only issue 'select' from the view.

Rahul

> ----------
> From: Oracle DBA[SMTP:oracle_dba_guru_at_yahoo.com]
> Reply To: Oracle DBA
> Sent: 16 Oktober 2000 11:28
> To: Lazy
> Cc: Vilas V. Sarangdhar; Santosh Arabatti; Shashi; Upendra Kolhatkar; P. Shivasankaran; Jacinto Fernandes; N. Sunil; V. Seshathrinathan; Rajesh Rao; Rahul Vilas Dandekar
> Subject: v$views
>
> Hello,
>
> I am probably making some silly mistake... But I cannot understand following...
>
> This is from catalot.sql
>
> create or replace view v_$datafile as
> select * from v$datafile;
> drop public synonym v$datafile;
> create public synonym v$datafile for v_$datafile;
>
>
> 1. You create v_$datafile by selecting from v$datafile
>
> 2. Drop the public synonym v$datafile
>
> 3. And create public synonym v$datafile for v_$datafile
>
> Doesn't it seem cyclic and mysterious?
>
Received on Mon May 15 2000 - 23:37:25 CDT