RE: v$views

Rahul,

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

It is not a standard security procedure so that public can issue select from that view. It's just for simpilicity purpose that the user need to know who is the owner of the view and does not have to reference the schema of that object.

The public will still need the owner to grant them select privilege in order to select from it. I think you can confuse this with the command "grant public".

Winnie

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rahul Sent: Monday, May 15, 2000 10:55 PM
To: Multiple recipients of list ORACLE-L Subject: 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?
>
> TIA,
>
> -Rahul
>
>
>
>

--
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may