Oracle 12.1 MV out of place refresh
From: Sanjay Mishra <"Sanjay>
Date: Tue, 14 Aug 2018 22:00:38 +0000 (UTC)
Message-ID: <967297443.7973981.1534284038013_at_mail.yahoo.com>
Date: Tue, 14 Aug 2018 22:00:38 +0000 (UTC)
Message-ID: <967297443.7973981.1534284038013_at_mail.yahoo.com>
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.
TIASanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2018 - 00:00:38 CEST