how do you know who has dblink to connect to your machine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how do you know who has dblink to connect to your machine

  1. #1
    Join Date
    Apr 2002
    Posts
    61

    Question

    Hi,
    I am looking for name of a view or table where you find info as far as who has a dblink created on their machines to conect to your machine (database)?
    I need to find out all the other databases that has a dblink to connect to my database.
    select * from dba_db_links gives the dblink that you have created on your own machine to connect to other databases.

    Thanks,
    Ramesh

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I'm pretty sure a db_link is a two way street, if it shows up on one box it shows on the other. You can verify this with dba_db_links;

    SQL>select * from dict where table_name like 'DBA_DB_LINKS';

    TABLE_NAME COMMENTS
    ------------------------------ -----------------------------------
    DBA_DB_LINKS All database links in the database

    MH

    [Edited by Mr.Hanky on 09-03-2002 at 02:50 PM]
    I remember when this place was cool.

  3. #3
    Join Date
    Jun 2002
    Location
    Denver
    Posts
    54
    I'm not sure if there is system table which gives this information, but I'm sure other DB person can not create a DB link to your DB unless he/she is given a username/password to connect to. So if security is your concern (in case you have 'inherited' the DB from someone) change all the passswords.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by rkonda99
    Hi,
    I am looking for name of a view or table where you find info as far as who has a dblink created on their machines to conect to your machine (database)?
    Look no further, there is no such view or table. You have no control from your database who and from which database can create and use (or has allready created) database link that connects to your database. As long as he/she has account (username, password) and a CREATE SESSION privilege on your database he can create and use database link from any other database where he/she has a CREATE DATABASE LINK privilege.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width