[BUG]oracle数据源接入选择数据表报错

[Xindong66]

SQLBot Version
1.2.0
Run Mode
docker
Describe the bug
oracle数据源接入选择数据表会报这个错误
Get table Failed: ('(oracledb.exceptions.DatabaseError) ORA-00942: table or view does not exist\nHelp: https://docs.oracle.com/error-help/db/ora-00942/',)

oracle版本号：Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Screenshots

[xuwei-fit2cloud]

帮忙确认一下：

• 用户是否有权限
• 指定的 schema 下是否存在表和视图

[yinchuan9527]

SELECT 
    t.TABLE_NAME AS "TABLE_NAME",
    NVL(c.COMMENTS, '') AS "TABLE_COMMENT"
FROM (
    SELECT TABLE_NAME, 'TABLE' AS OBJECT_TYPE
    FROM DBA_TABLES
    WHERE OWNER = :param  
    UNION ALL
    SELECT VIEW_NAME AS TABLE_NAME, 'VIEW' AS OBJECT_TYPE
    FROM DBA_VIEWS
    WHERE OWNER = :param  
) t
LEFT JOIN DBA_TAB_COMMENTS c 
    ON t.TABLE_NAME = c.TABLE_NAME 
    AND c.TABLE_TYPE = t.OBJECT_TYPE
    AND c.OWNER = :param   
ORDER BY t.TABLE_NAME

• 应该是没有 DBA_* 相关权限导致
• 针对这种情况是否可以采用 USER_* 替代，或者支持手动输入表
• 另外是否可以加入 视图、物化视图、同义词

[xuwei-fit2cloud]

• 我们会对涉及到的表权限进行优化，尽量不涉及 DBA_*等表的权限
• 视图和物化视图目前是支持的，同义词暂时没有计划