Users without SELECT ANY DICTIONARY cannot create scripts for tables, views, or Materialized Views in Oracle 23c (4374057)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

Users without SELECT ANY DICTIONARY cannot create scripts for tables, views, or Materialized Views in Oracle 23c
説明

Users without SELECT ANY DICTIONARY cannot create scripts for tables, views, or Materlialized Views in Oracle 23c.

Steps to replicate -

- Log into 23c as SCOTT or some user who does not have the SELECT ANY DICTIONARY system privilege

- Go to Schema Browser

- Select a table and go to the RHS Script tab

Bug: “Invalid table name” error
原因

Product Defect - TOR-7711
対策

WORKAROUND
Grant the below and the error will go away. Please reconnect Toad after receiving the grant.

grant read on DBA_ANNOTATIONS_USAGE to (your user name);

Grant this to public for everyone.

STATUS
Waiting for fix in a future release of Toad for Oracle.
Defect ID

TOR-7711

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

タイトル