Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01997 – GRANT failed: user 'string' is identified externally

Oracle Database Error Code ORA-1997 Description :

GRANT failed: user 'string' is identified externally

Error Cause:

You cannot grant the SYSOPER or SYSDBA privilege to a user created with the IDENTIFIED EXTERNALLY clause.

How to Solve :

If you wish to grant the user the SYSOPER or SYSDBA privileges, drop and re-create the user without the IDENTIFIED EXTERNALLY clause.