Oracle Database Errors or Warnings from Error ORA-01921 to ORA-01930



ORA-01921: role name ‘string’ conflicts with another user or role name
Cause: There is already a user or role with that name.
Action: Specify a different role name.
ORA-01922: CASCADE must be specified to drop ‘string’
Cause: Cascade is required to remove this user from the system. The user own’s object which will need to be dropped.
Action: Specify cascade.
ORA-01923: CASCADE aborted, objects locked by another user
Cause: Cannot drop the user’s objects; someone has them locked.
Action: Use the lock monitor to determine who has the objects locked.

ORA-01924: role ‘string’ not granted or does not exist
Cause: Either the role was not granted to the user, or the role did not exist.
Action: Create the role or grant the role to the user and retry the operation.
ORA-01925: maximum of string enabled roles exceeded
Cause: The INIT.ORA parameter “max_enabled_roles” has been exceeded.
Action: Increase max_enabled_roles and warm start the database.
ORA-01926: cannot GRANT to a role WITH GRANT OPTION
Cause: Role cannot have a privilege with the grant option.
Action: Perform the grant without the grant option.

ORA-01927: cannot REVOKE privileges you did not grant
Cause: You can only revoke privileges you granted.
Action: Don’t revoke these privileges.
ORA-01928: GRANT option not granted for all privileges
Cause: In order to grant a privilege, you must first have the privilege with the grant option.
Action: Obtain the privilege with the grant option and try again.
ORA-01929: no privileges to GRANT
Cause: “ALL” was specified but the user doesn’t have any privileges with the grant option.
Action: Don’t grant privileges on that object.
ORA-01930: auditing the object is not supported
Cause: AUDIT or NOAUDIT was specified for an object that cannot be audited.
Action: Don’t attempt to AUDIT the object.

Above are list of Oracle Database Errors or Warnings from Error ORA-01921 to ORA-01930 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.

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 *