Re: problem with ORA-02019

You create a private database link called DB2.WORLD to a remote user on DB2, and then create a view as SELECT * FROM TABLE_NAME_at_DB2.WORLD. You then grant privileges on the view to USER2.  

When USER2 selects from the view, an ORA-02019 error is returned. If there is a PUBLIC database link with the same name as your private link name, then an ORA-01017 error is returned instead.  

Per the V7.3 Distributed System Guide, Volume 1, Page 4-13 and 4-14, a user should be able to allow access through a view with a private link without giving up the username and password. In this example, you have access to the remote user's tables by knowing the remote username/password and USER2 does not. USER2 only has access to the view. You do not want USER2 to have access to the remaining objects owned by the remote user.

Workaround:

Create a public database link of the same name in the schema of USER2.

Note: This gives USER2 access to all of the objects owned by the

       remote user. Received on Thu Sep 05 2002 - 19:41:29 CDT