Oracle 26ai

ORA-01932

Cause

A role can be granted to another user or role only if the role has been granted WITH ADMIN OPTION.


Action

Grant the privilege or role to the user WITH ADMIN OPTION and retry the operation.