Hello,
I have an 11.2.0.3 RMAN Catalog. I need to grant select access on the RC_RMAN_BACKUP_JOB_DETAILS view to a user who will be querying this view to produce reports. I can select data from this view as sys, however when I create a new user TEST, and grant select on this view, I can not select data from this view. Any idea why? This is an 11.2.0.3 database running on OEL 6. Please see the example below.
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 29 17:07:03 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select count (*) from RCAT.RC_RMAN_BACKUP_JOB_DETAILS;
COUNT(*)
----------
27593
SQL> create user TEST identified by welcome1;
User created.
SQL> grant select on RCAT.RC_RMAN_BACKUP_JOB_DETAILS to TEST;
Grant succeeded.
SQL> grant connect to TEST;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
$ sqlplus TEST
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 29 17:08:20 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select count (*) from RCAT.RC_RMAN_BACKUP_JOB_DETAILS;
COUNT(*)
----------
0
SQL> select * from RCAT.RC_RMAN_BACKUP_JOB_DETAILS;
no rows selected