Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-00954

missing IDENTIFIED keyword

Cause

A GRANT CONNECT statement was issued without the keyword IDENTIFIED.


Action

Check the syntax and insert the keyword IDENTIFIED after the last username. The format is

GRANT CONNECT TO user-list IDENTIFIED BY password-list;