ORA-01931
cannot grant "string" to a role
Cause
An attempt to grant privileges to a role failed. UNLIMITED TABLESPACE, REFERENCES, INDEX, or administrative privileges such as SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC cannot be granted to a role.
Action
Grant the desired privilege directly to the user. For administrative privilege grants, some additional restrictions apply :
- SYSBACKUP, SYSDG, or SYSKM administrative privileges can be granted only when the password file is in Oracle 12c or later format.
- SYSASM administrative privilege can be granted only when connected to an Oracle Automatic Storage Management (Oracle ASM) instance.
- SYSRAC administrative privilege cannot be granted to a user because only operating system authentication is supported for SYSRAC privilege.