Oracle DB Error ORA-00993 missing GRANT keyword

The following in the cause of this error:

The keyword WITH was specified at the end of a GRANT statement without the keyword GRANT. To grant privileges to a user and the permission to grant those privileges to another user, you must specify the keywords WITH GRANT OPTION at the end of the GRANT statement.

Action you can take to resolve this issue: Change the keyword WITH to the keywords WITH GRANT OPTION, then retry the statement.

Tags: Database, Education, Software

Related