Help needed: grant/synonym technique

From: Marco.Tosi <tosi_at_bpb.it>
Date: 10 Dec 1993 05:34:30 -0600
Message-ID: <9312101129.AA18409_at_bpb.it>


Hello,

My configuration is: SparcStation 10

                      SunOS 4.1.3 DBE
                      ORACLE 6.0.36.7.1

and I have the following situation:

  • User OPS$ONE

SQL> CREATE TABLE tab_one (col_one char(1)); SQL> GRANT ALL ON tab_one TO PUBLIC;

  • User OPS$DBA

SQL> CREATE PUBLIC SYNONYM tab_one FOR OPS$ONE.tab_one;

  • User OPS$TWO
SQL> CREATE TABLE tab_two (col_two char(1));
SQL> GRANT ALL ON tab_two TO PUBLIC;
SQL> CREATE VIEW view_two AS SELECT col_one,col_two FROM tab_one, tab_two;
SQL> GRANT ALL ON view_two TO PUBLIC;

  • User OPS$DBA

SQL> CREATE PUBLIC SYNONYM tab_two FOR OPS$TWO.tab_two; SQL> CREATE PUBLIC SYNONYM view_two FOR OPS$TWO.view_two;    

  • User OPS$THREE

SQL> desc tab_one  

Name                            Null?    Type
------------------------------- -------- ----
COL_ONE                                  CHAR(1)
 

SQL> desc tab_two  

Name                            Null?    Type
------------------------------- -------- ----
COL_TWO                                  CHAR(1)
 
 

SQL> SELECT * FROM view_two;  

ERROR:
ORA-00942: table or view does not exist          

What is wrong ???
Any comments or suggestions would be appreciated !!!  

Thanks a lot.
Marco  

P.S. Please email directly to tosi_at_bpb.it  


Name       : Marco Tosi
Company    : Banca Popolare di Bergamo - Credito Varesino
Address    : Piazza V.Veneto, 8 - 24122 Bergamo - Italy
email      : tosi_at_bpb.it
-----------------------------------------------------------------------
Received on Fri Dec 10 1993 - 12:34:30 CET

Original text of this message