Error
Error Code:
ORA-28709
Oracle ORA-28709: Invalid Grantee Type
Description
The ORA-28709 error occurs in Oracle Database when you attempt to grant a role with the `DELEGATE` option to a grantee that is not a user. The `DELEGATE` option allows the grantee to further grant the role to other users, but this capability is restricted to user accounts only.
Error Message
ORA-28709: Roles with DELEGATE option can only be granted to users.
Known Causes
3 known causesGrantee is a Role
You attempted to grant a role with the `DELEGATE` option to another role, which is not permitted. Roles with `DELEGATE` can only be granted to users.
Grantee is a System Privilege
You attempted to grant a role with the `DELEGATE` option to a system privilege. Roles with `DELEGATE` can only be granted to users.
Typographical Error
A typo in the `GRANT` statement resulted in an unintended non-user principal being specified as the grantee.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service