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