Problem with privileges and synonyms

From: Gerard Lacroix <kochel_verz_at_yahoo.com>
Date: 6 Mar 2006 05:41:53 -0800
Message-ID: <1141652513.108520.315900@v46g2000cwv.googlegroups.com>

I wonder if you can help to understand this. Cannot desc on a table unless I include the owner, but I can do a select without it. (T_USER table)
Look for synonyms and don't see any defined against the table. Why can I select without the owner, what am I doing wrong ?

Connected to Oracle9i Enterprise Edition Release 9.2.0.6.0 Connected as TEL_APP

SQL> select * from session_privs;

PRIVILEGE

---

CREATE SESSION
ALTER SESSION SQL> select * from session_roles;

ROLE

---

TEL_APP_ROLE SQL> select role, owner, privilege
  2 from role_tab_privs where table_name = 'T_USER';

ROLE OWNER PRIVILEGE
------------------ --------- ---------------

TEL_APP_ROLE       SCOTT     DELETE
TEL_APP_ROLE       SCOTT     INSERT
TEL_APP_ROLE       SCOTT     SELECT
TEL_APP_ROLE       SCOTT     UPDATE

SQL> desc t_user
Object t_user does not exist.

SQL> desc SCOTT.t_user

Name                   Type         Nullable Default   Comments


---------------------- ------------ -------- --------- --------

USERID                 VARCHAR2(10)
LASTLOGIN              DATE         Y
EMAIL                  VARCHAR2(50) Y

SQL> select count(*) from t_user;

  COUNT(*)

---

        68

SQL> select * from all_synonyms where table_name = 'T_USER';

OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
---------- ----------------- ------------- ------------ ----------

SQL> Received on Mon Mar 06 2006 - 07:41:53 CST