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

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

In Toad 11.6, get Ora-01031 error trying to connect to 12c database
Descrição

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.
Resolução

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

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

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título