Database Administration (MOSC)

MOSC Banner

ORA-01017 on an external authetication

Hello,

I have ORA-01017: invalid username/password; logon denied error message when I'm testing the external authentication with SSL.

It was working until a few days without any issueS.

The certificate is still valid.

Can you please give an idea of where to look?


I have recreated the user CLIENT :

create user client identified externally as 'CN=client';

grant create session to "CLIENT";

GRANT SELECT ANY TABLE TO "CLIENT" ;

GRANT SELECT ANY TABLE TO "CLIENT" ;

GRANT CREATE ANY TABLE TO "CLIENT" ;

GRANT UPDATE ANY TABLE TO "CLIENT" ;

GRANT INSERT ANY TABLE TO "CLIENT" ;

GRANT DROP ANY TABLE TO "CLIENT" ;

Thank you,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center