|
Re: how to grant database link to user [message #633381 is a reply to message #633380] |
Tue, 17 February 2015 06:14 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Not sure what you are actually asking for. But I guess you need to create a private database link for the other user. For all users, you could create a public database link.
Why not start reading more about it in the documentation. You could also have a look at our wiki Database link
Regards,
Lalit
|
|
|
Re: how to grant database link to user [message #633382 is a reply to message #633381] |
Tue, 17 February 2015 06:20 |
qanita786
Messages: 229 Registered: May 2007 Location: PAKISTAN
|
Senior Member |
|
|
Dear I am Creating The Following Link
create public database link link2014 connect to account identified by a using 'main'
it work only with account user i want that any user can select data from link2014
|
|
|
Re: how to grant database link to user [message #633387 is a reply to message #633382] |
Tue, 17 February 2015 06:40 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Can you show us using copy paste from your SQL*Plus session that what you claim is correct.
For example,
SQL> show user;
USER is "LALIT"
SQL> DROP PUBLIC DATABASE LINK TEST_DB_LINK;
Database link dropped.
SQL>
SQL> CREATE PUBLIC DATABASE LINK "TEST_DB_LINK"
2 CONNECT TO user
3 IDENTIFIED BY Asdf1234
4 USING '**********';
Database link created.
SQL> select * from dual@TEST_DB_LINK;
D
-
X
SQL> conn scott/tiger@pdborcl
Connected.
SQL> show user
USER is "SCOTT"
SQL> select * from dual@TEST_DB_LINK;
D
-
X
SQL>
|
|
|
|
Re: how to grant database link to user [message #633389 is a reply to message #633388] |
Tue, 17 February 2015 06:46 |
qanita786
Messages: 229 Registered: May 2007 Location: PAKISTAN
|
Senior Member |
|
|
Dear I am Creating The Following Link
create public database link link2014 connect to account identified by a using 'main'
its fine with account users in Forms 6i if i Connect with Account user if i Connect With Lalit User Its Generate an Error
|
|
|
|
Re: how to grant database link to user [message #633391 is a reply to message #633390] |
Tue, 17 February 2015 07:18 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
>if i Connect With Lalit User Its Generate an Error
Does the user exist? What is the error? I don't see any error, because you didn't post any error details. I have shown you above how to copy paste.
|
|
|
|
|
|
|
Re: how to grant database link to user [message #633397 is a reply to message #633394] |
Tue, 17 February 2015 09:36 |
qanita786
Messages: 229 Registered: May 2007 Location: PAKISTAN
|
Senior Member |
|
|
I Create a User By Name Faheem in Both Database and Assign a Selection of Data Role When i apply This Command Following Error Occured
select path from interface@link2014
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from LINK2014
|
|
|
|
|
|
|
|
Re: how to grant database link to user [message #633408 is a reply to message #633397] |
Tue, 17 February 2015 15:38 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
qanita786 wrote on Tue, 17 February 2015 10:36I Create a User By Name Faheem in Both Database and Assign a Selection of Data Role When i apply This Command Following Error Occured
select path from interface@link2014
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from LINK2014
We don't know WHERE you created the user.
We don't know WHERE you granted the privileges.
We don't know WHERE you executed the command.
How hard is it to show your session by cut and paste that has been asked multiple times?
|
|
|
|