<span class="normal">"ORA-00604:error occurred at recursive SQL Level 1 ORA-00001: unique constra (4309928)

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

戻る

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

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

評価を選択

タイトル

"ORA-00604:error occurred at recursive SQL Level 1 ORA-00001: unique constra
説明

Created role TEST_ROLE
In SB Roles - Granted all three grant types to user USER1 i.e. 'Granted', 'Admin' and 'Default'
<right Click> TEST_ROLE | Configure Grantees | uncheck 'admin' | OK
resulted in the following error:

"Error: ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_DEFROLE1) violated"

On checking the SQL that Toad fires off it's doing the following:

ALTER USER "USER1"
DEFAULT ROLE "TEST_ROLE", "TEST_ROLE"

TEST_ROLE has been duplicated in the ALTER USER COMMAND, hence the constraint violation
対策

WORKAROUND

none

STATUS

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

ST68618

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

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

評価を選択

推奨コンテンツ

タイトル