Oracle Database Errors or Warnings from Error ORA-01931 to ORA-01940

SQLServerF1

 

ORA-01931: cannot grant string to a role
Cause: UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA, SYSOPER or SYSASM privilege could not be granted to a role.
Action: Grant privilege directly to the user.
ORA-01932: ADMIN option not granted for role ‘string’
Cause: The operation requires the admin option on the role.
Action: Obtain the grant option and re-try.
ORA-01933: cannot create a stored object using privileges from a role
Cause: An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.
Action: Grant the privileges required to the user directly.

ORA-01934: circular role grant detected
Cause: Roles cannot be granted circularly. Also, a role cannot be granted to itself.
Action: Do not perform the grant.
ORA-01935: missing user or role name
Cause: A user or role name was expected.
Action: Specify a user or role name.
ORA-01936: cannot specify owner when creating users or roles
Cause: Users and roles do not have owners.
Action: Don’t specify an owner.

ORA-01937: missing or invalid role name
Cause: A valid role name was expected.
Action: Specify a valid role name.
ORA-01938: IDENTIFIED BY must be specified for CREATE USER
Cause: Cannot create a user without specifying a password or “IDENTIFIED EXTERNALLY”.
Action: Specify one of the password clauses.
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 these privileges.
Action: Specify the admin option.
ORA-01940: cannot drop a user that is currently connected
Cause: Attempt was made to drop a user that is currently logged in.
Action: Make sure user is logged off, then repeat command.

Above are list of Oracle Database Errors or Warnings from Error ORA-01931 to ORA-01940 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *