Oracle DB Error ORA-01997 GRANT failed: user string is identified externally

The following is the cause of this error:

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

Action you can take to resolve this issue: If you wish to grant the user the SYSOPER or SYSDBA privileges, drop and re-create the user without the IDENTIFIED EXTERNALLY clause.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related