novice learns a new thing

[novicedba]

Hi all,  I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help   =========================================================== SQL> conn hlledw/hlledw@orcl9i Connected. SQL> grant select on edw_week_lvl to scott;   Grant succeeded.   SQL> grant select on edw_week_lvl to test1;   Grant succeeded.   SQL> conn scott/tiger@orcl9i Connected. SQL> desc hlledw.edw_week_lvl  Name                            Null?    Type  ------------------------------- -------- ----  ID                              NOT NULL NUMBER(5)  CODE                            NOT NULL VARCHAR2(16)  DSC                             NOT NULL VARCHAR2(40)  END_DATE                        NOT NULL DATE  TIMESPAN                        NOT NULL NUMBER(3)   SQL> conn test1/test1@orcl9i Connected. SQL> desc hlledw.edw_week_lvl  Name                            Null?    Type  ------------------------------- -------- ----  ID                              NOT NULL NUMBER(5)  CODE                            NOT NULL VARCHAR2(16)  DSC                             NOT NULL VARCHAR2(40)  END_DATE                        NOT NULL DATE  TIMESPAN                        NOT NULL NUMBER(3)   SQL> desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist   SQL> conn scott/tiger@orcl9i Connected. SQL> create synonym edw_week_lvl for hlledw.edw_week_lvl;   Synonym created.   SQL> desc edw_week_lvl  Name                            Null?    Type  ------------------------------- -------- ----  ID                              NOT NULL NUMBER(5)  CODE                            NOT NULL VARCHAR2(16)  DSC                             NOT NULL VARCHAR2(40)  END_DATE                        NOT NULL DATE  TIMESPAN                        NOT NULL NUMBER(3)   SQL> conn test1/test1@orcl9i Connected. SQL>  desc hlledw.edw_week_lvl  Name                            Null?    Type  ------------------------------- -------- ----  ID                              NOT NULL NUMBER(5)  CODE                            NOT NULL VARCHAR2(16)  DSC                             NOT NULL VARCHAR2(40)  END_DATE                        NOT NULL DATE  TIMESPAN                        NOT NULL NUMBER(3)   SQL>  desc scott.edw_week_lvl  Name                            Null?    Type  ------------------------------- -------- ----  ID                              NOT NULL NUMBER(5)  CODE                            NOT NULL VARCHAR2(16)  DSC                             NOT NULL VARCHAR2(40)  END_DATE                        NOT NULL DATE  TIMESPAN                        NOT NULL NUMBER(3)   SQL> =================================================================   This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS   An obstacle is something you see when you take your eyes off the goal -- Anonymous