Error / Problem: select statement returns no rows – but result set contains about 3 rows (from CW_ALL_DB_LINKS / sys.link$ / Oracle9i)

CAST Application Mining Error/Problem:

Following select statement returns no rows – but result set contains about 3 rows

Thu May 27 11:19:18 2004: Query sent:
Thu May 27 11:19:18 2004: SELECT 1020, db_link, ‘V’, -1, host, UserName
Thu May 27 11:19:18 2004: FROM CW_ALL_DB_LINKS
Thu May 27 11:19:18 2004: WHERE ( owner = ‘PUBLIC’ )
Thu May 27 11:19:18 2004: —

It seems as on 9i the privilege SELECT ANY TABLE excludes the “sys.link$” table! Now we try with direct grants on these objects.

SELECT *
FROM sys.link$

Solution:
Permission missing: GRANT SELECT ON SYS.LINK$ TO CAST