ORA-01939
invalid option specified for WITH clause in the GRANT statement
Cause
An invalid option was specified in the WITH clause. When granting SYSTEM privileges and ROLES, the WITH clause can only have either ADMIN OPTION or DELEGATE OPTION.
Action
If granting a system privilege, specify ADMIN OPTION in the WITH clause. If granting a role, specify either ADMIN OPTION or DELEGATE OPTION in the WITH clause.
ORA-01939
only the ADMIN OPTION can be specified
Cause
System privileges and roles can only be granted with the admin option. The grant option cannot be used with system privileges and roles. The delegate option cannot be used with system privileges.
Action
Specify the admin option.
ORA-01939
only the ADMIN OPTION can be specified
Cause
System privileges and roles can only be granted with the admin option. The grant option cannot be used with system privileges and roles. The delegate option cannot be used with system privileges.
Action
Specify the admin option.
