Re: something magic about SYS.LINK$ ?

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 02 Sep 2005 18:06:04 +0200
Message-ID: <43187850$0$24162$9b4e6d93@newsread4.arcor-online.net>

EdStevens schrieb:
> Oracle 9.2.0.7.0 on Win2003
>
> Stumbled on to this, and don't have an explanation:
>
> Connected as SYSTEM, with the standard, out-of-the-box DBA role:
>
> system_at_NPSTDB.WORLD> select count(*) from sys.link$;
> select count(*) from sys.link$
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> A little further hunting shows that there are only 2 of the sys.$
> tables that this happens on ... SYS.LINK$ and SYS.USER_HISTORY$
>
>
> ???
>

Maybe issue of O7_dictionary_accessibility ? If set to FALSE, all tables owned by SYS must be granted explicitly ( select any table combined with select any dictionary are not sufficient ).

Best regards

Maxim Received on Fri Sep 02 2005 - 11:06:04 CDT