Hi,
A user want to access sys.link$ table. SYS has granted SELECT_CATALOG_ROLE to that user and also enabled O7_DICTIONARY_ACCESSIBILITY to TRUE. These settings didn't help that particular user to acess sys.link$.
settings on Oracle Server are as follows...
SQL> show parameter o7_
NAME TYPE VALUE
------------------------------------ ----------- -----
O7_DICTIONARY_ACCESSIBILITY boolean TRUE
SQL>
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL>
Could anybody please help?