In Toad 11.6, get Ora-01031 error trying to connect to 12c database (4238278)

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

In Toad 11.6, get Ora-01031 error trying to connect to 12c database
Descrizione

When connecting to an Oracle 12.1.0.2 database, using Toad 11.6.0.43, with a regular user, the following error message is received.

"Ora-01031 Insuficient priviliges"

After this The connection works ok.

When connecting to Oracle 10.2.0.4 database, with the same regular user, there is no error.

Both have all privileges to connect and resource.
Causa

Oracle 12.1.0.2 changed some things in the data dictionary that are causing this. Specifically, the table SYS.USER$ is no longer included in the SELECT ANY DICTIONARY system privilege. So what's happening is that Toad is detecting that the user has SELECT ANY DICTIONARY, and assuming because of that, the user can select from the SYS.USER$ table.
Risoluzione

RESOLUTION #1:
Grant SYS.USER$ to the user.

RESOLUTION #2:
Upgrade to the current version of Toad, which you can download here.

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Cronologia articoli:: Data di creazione: 10/13/2015
Ultimo aggiornamento: 5/7/2023

Titolo