Skip to content
Home » Oracle » How to Resolve ORA-01939: only the ADMIN OPTION can be specified

How to Resolve ORA-01939: only the ADMIN OPTION can be specified

ORA-01939

Tried to grant a system privilege to an user, but it failed with ORA-01939.

SQL> grant select any table to sh with grant option;
grant select any table to sh with grant option
                                  *
ERROR at line 1:
ORA-01939: only the ADMIN OPTION can be specified

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

SQL> grant select any table to sh with admin option;

Grant succeeded.

That's it.

Leave a Reply

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