Re: DBlink

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 18 Nov 1999 18:20:56 GMT
Message-ID: <19991118132056.01916.00000294@ngol02.aol.com>

In article <01bf3159$e581c280$a504fa80_at_mndnet>, "Suresh Bhat" <suresh.bhat_at_mitchell-energy.com> writes:

>Hi,
>
>You must have either internal or sys DBA Oracle account to get to the link$
>account.
>
>Usually no other account can get to *$ tables except sys and internal.
>
>However, you can query all_db_links via any other account.
>

NOT EXACTLY... SQL>connect scott/tiger
connected

SQL> select * from sys.link$;
select * from sys.link$

                  *

ERROR at line 1:
ORA-00942: table or view does not exist

SQL>connect system/manager
connected

SQL>GRANT SELECT ANY TABLE TO SCOTT; SQL>connect scott/tiger
connected

SQL>select * from sys.link$;

no rows selected

Paul in VT Received on Thu Nov 18 1999 - 12:20:56 CST