https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE- CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC Examples Example 2-70 Creating a Recovery Catalog and Registering a Database Assume that you start SQL*Plus and connect to the recovery catalog catdb with administrator privileges. You execute the CREATE USER statement as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords). The SQL statement creates a user rco in database catdb and grant the rco user the RECOVERY_CATALOG_OWNER role.
SQL> CREATE USER rco IDENTIFIED BY password
2 DEFAULT TABLESPACE cattbs
3 QUOTA UNLIMITED ON cattbs;
SQL> GRANT recovery_catalog_owner TO rco;
SQL> EXIT