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>
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