How to fix the Oracle error RMAN-07522: CREATE TYPE privilege must be granted to user string?

In this post, you’ll learn more about the Oracle ErrorRMAN-07522: CREATE TYPE privilege must be granted to user string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-07522: CREATE TYPE privilege must be granted to user string

Reason for the Error RMAN-07522: CREATE TYPE privilege must be granted to user string

The CREATE CATALOG or UPGRADE CATALOG command was used, but the USERID that was supplied in the CATALOG connect string does not have the CREATE TYPE privilege granted.

How to fix the Error RMAN-07522: CREATE TYPE privilege must be granted to user string ?

You can fix this error in Oracle by following the below steps

Grant CREATE TYPE privilege to the recovery catalog owner.