ORA-00924

Error: ORA-00924: missing BY keyword

Causa: The keyword BY was omitted in a GROUP BY, ORDER BY, or CONNECT BY clause. In a GRANT statement, the keyword IDENTIFIED must also be followed by the keyword BY.

Acción: Correct the syntax. Insert the keyword BY where required and then retry the statement.