This is documented:
Oracle 12c: Refresh MView With Out Of Place True causes loss of GRANTS (Doc
ID 2010976.1)
On Wed, Aug 15, 2018 at 5:00 AM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Does anyone experience issue with 12.1 Out of place refresh permission
issue to roles? I had a Role who is granted select access to the MV but
whenever MV is refreshed out of place, the permission is removed. So look
like when the table is switched, old Table with same will be removed and
after new table replaces it, permission will no longer be available.
Does anyone experience the same issue? I had to put logic now to add
select to the role after all refresh. Not sure if it is an issue or
something bug in my version which is pretty much up-to date and even has
the patch to fix some of the MV out of place refresh bugs.
TIA
Sanjay
