List backups problem while selecting backups with another user

[rafiki]

When we configure rman backup with catalog database we can only see backups with which user create backup, who is rcat_devnew.For example;

-When we connect with backup owner "rcat_devnew" we can use below query and we can see all backups;

select * from rcat_devnew.RC_BACKUP_SPFILE;

-But when I connect with my db user,query return null,

select * from rcat_devnew.RC_BACKUP_SPFILE;

Which privilige requires?

And also I have to say there is an interesting situation.

I cant use this select for DEV database but I can use this select our other database TEST?!!!

I checked all priviliges but couldnt find any difference between TEST and DEV database...

We upgraded these database from 11.2.0.4 to 12.2 version

[ErmanArslansOracleBlog]

It is probably due to database version being 12C..

Is your catalog, a base recovery catalog or a virtual private catalog?

A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases.
A virtual private catalog is a set of security policies that restrict user access to a subset of a base recovery catalog.

[rafiki]

Thank your Erman , I researched private catalog and found a soluiton;

rman target / catalog rcat_test/Rcat_test@CATALOGDB
grant catalog for database test to backupuser;