Home » SQL & PL/SQL » SQL & PL/SQL » creating database links for other user (oracle 9i , solaris)
creating database links for other user [message #361395] Wed, 26 November 2008 04:20 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi All,
As Administrator,I connected as "system" account.
When creating database link , the owner of this database link is
system . But i would like that this database link own to user "Diane"

How can I proceed ?

Thanks for all

koff
Re: creating database links for other user [message #361397 is a reply to message #361395] Wed, 26 November 2008 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: creating database links for other user [message #361404 is a reply to message #361395] Wed, 26 November 2008 05:02 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way would be to
- connect as 'system'
- GRANT CREATE DATABASE LINK TO diane
- connect as 'diane'
- CREATE DATABASE LINK ...
Re: creating database links for other user [message #361405 is a reply to message #361395] Wed, 26 November 2008 05:11 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Recreate the Database link.

Drop the database link and recreate it from "Diane".

OR

Use CREATE DATABASE LINK DIANE.DBLINKNAME ......


Smile
Rajuvan.
Re: creating database links for other user [message #361409 is a reply to message #361405] Wed, 26 November 2008 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
CREATE DATABASE LINK DIANE.DBLINKNAME

Wrong!

SQL> sho user
USER is "MICHEL"
SQL> create database link scott.dblink connect to scott identified by tiger using 'mika';

Database link created.

SQL> col db_link format a40
SQL> select owner, db_link from dba_db_links;
OWNER                          DB_LINK
------------------------------ ----------------------------------------
MICHEL                         SCOTT.DBLINK

Regards
Michel
Re: creating database links for other user [message #361414 is a reply to message #361395] Wed, 26 November 2008 05:48 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Oooops ./fa/1587/0/ Its my mistake !!!

Smile
Rajuvan
Re: creating database links for other user [message #361431 is a reply to message #361404] Wed, 26 November 2008 06:51 Go to previous message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Thanks for all

koff
Previous Topic: Problem while Dequeuing message (merged)
Next Topic: Extracting Days,Hours between 2 dates
Goto Forum:
  


Current Time: Fri Dec 02 18:29:48 CST 2016

Total time taken to generate the page: 0.34339 seconds