ORA-00924
missing BY keyword
Cause
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.
Action
Correct the syntax. Insert the keyword BY where required and then retry the statement.