List backups problem while selecting backups with another user

Posted by rafiki on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/List-backups-problem-while-selecting-backups-with-another-user-tp5420.html

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