Insufficient privileges issue on a view when user has privileges on the view and underlying table
Posted on 2013-05-16
User USR1 has been granted select on MGMT$HA_BACKUPS, and unser USR1 schema a view has been created on MGMT$HA_BACKUPS called USR1.USR1_BACKUPS.
There is a USR2 that has SELECT privileges on MGMT$HA_BACKUP table and USR1.USR1_BACKUPS view, but when I attempt select * from USR1.USR1_BACKUPS while logged in as USR2, I get an error below:
SQL> select * from USR1.USR1_BACKUPS;
select * from USR1.USR1_BACKUPS;
ERROR at line 1:
ORA-01031: insufficient privileges