Privileges Database Link

From: The Magnet <art_at_unsu.com>
Date: Mon, 24 May 2010 11:18:41 -0700 (PDT)
Message-ID: <292bab99-411b-4fbf-afff-aec0a66c900a_at_k25g2000prh.googlegroups.com>

We have 2 database which have DB links between. The user in both database have the same name. We cannot figure out how to grant the privileges.

SQL> grant select on status to john_at_comm.zacks.com; grant select on status to john_at_comm.zacks.com

                                    *

ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> grant select on status to john;
grant select on status to john

                          *

ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

Help please. Received on Mon May 24 2010 - 13:18:41 CDT