Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

access sys.link$ table

639458Mar 9 2010 — edited Mar 9 2010
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?
This post has been answered by 722837 on Mar 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2010
Added on Mar 9 2010
7 comments
2,438 views