Database Error Messages

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.

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.

An attempt to grant privileges to a role failed. UNLIMITED TABLESPACE, REFERENCES, INDEX, Administrative Privileges like SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC cannot be granted to a role.

Grant 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 format "12" or higher.
• SYSASM administrative privilege can be granted, only when connected to an ASM instance.
• SYSRAC administrative privilege cannot be granted to a user because only operating system authentication is supported for SYSRAC privilege.

An attempt to grant privileges to a role failed. UNLIMITED TABLESPACE, REFERENCES, INDEX, Administrative Privileges like SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC cannot be granted to a role.

Grant 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 format "12" or higher.
• SYSASM administrative privilege can be granted, only when connected to an ASM instance.
• SYSRAC administrative privilege cannot be granted to a user because only operating system authentication is supported for SYSRAC privilege.