C:\>sqlplus websystemd3/XXXXX@dev

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 18 10:00:59 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show user
USER is "WEBSYSTEMD3"   --> SCHEMA OWNER

SQL> select trigger_name from user_triggers d where d.BASE_OBJECT_TYPE='TABLE' and d.TABLE_NAME='EXCHANGERATE';

TRIGGER_NAME
------------------------------
INSERT_RATEDATE
EXCHANGERATE_TRG

SQL> desc EXCHANGERATE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 CREDITCURRENCYCODE                        NOT NULL VARCHAR2(3)
 DEBITCURRENCYCODE                         NOT NULL VARCHAR2(3)
 RATE                                               NUMBER
 DIVIDERATE                                         NUMBER
 RATEDATE                                           DATE
 MODIFYTYPE                                         VARCHAR2(5)
 ENTERED_BY                                         VARCHAR2(8)
 ENTERED_TIMESTAMP                                  DATE
 MODIFIED_BY                                        VARCHAR2(8)
 MODIFIED_TIMESTAMP                                 DATE
 HOUR                                               VARCHAR2(10)
 MINUTE                                             VARCHAR2(10)
 RATEEXPIRATION                                     DATE
 SCREENDATE                                         DATE
 MARKETCONVENTION                                   VARCHAR2(1)

SQL> Grant select, Insert,Update, delete on EXCHANGERATE  to websystemusrd3;

SQL> disconnect
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64
bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> conn  websystemusrd3/zzzzzz@dev
Connected.
SQL> show user
USER is "WEBSYSTEMUSRD3"      

SQL >  CREATE SYNONYM WEBSYSTEMUSRD3.EXCHANGERATE FOR WEBSYSTEMD3.EXCHANGERATE;

SQL> select count(*) from EXCHANGERATE;

  COUNT(*)
----------
       138

SQL>