Skip to content
Home » Oracle Database » User and Role » Privilege » How to Resolve ORA-00993: missing GRANT keyword

How to Resolve ORA-00993: missing GRANT keyword

ORA-00993

Tried to grant an object privilege to an user, but it failed with ORA-00993.

SQL> grant select on hr.employees to sh with admin option;
grant select on hr.employees to sh with admin option
                                        *
ERROR at line 1:
ORA-00993: missing GRANT keyword

ORA-00993 means that granting object privileges can't use WITH ADMIN OPTION, the only valid modifier is WITH GRANT OPTION.

SQL> grant select on hr.employees to sh with grant option;

Grant succeeded.

That's it.

Leave a Reply

Your email address will not be published. Required fields are marked *