Discussion:
Oracle 12.1 MV out of place refresh
"Sanjay Mishra" (Redacted sender "smishra_97" for DMARC)
2018-08-14 22:00:38 UTC
Permalink
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
Stefan Knecht
2018-08-15 04:51:29 UTC
Permalink
This is documented:

Oracle 12c: Refresh MView With Out Of Place True causes loss of GRANTS (Doc
ID 2010976.1)
Post by "Sanjay Mishra" (Redacted sender "smishra_97" for DMARC)
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
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | @zztat_oracle | fb.me/zztat | zztat.net/blog/
"Sanjay Mishra" (Redacted sender "smishra_97" for DMARC)
2018-08-15 20:32:40 UTC
Permalink
Thanks Stefan. this is what I am looking
Sanjay
On Wednesday, August 15, 2018, 12:52:43 AM EDT, Stefan Knecht <***@gmail.com> wrote:

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-***@freelists.org> 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.
TIASanjay
--
//zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!Visit us at zztat.net | @zztat_oracle | fb.me/zztat | zztat.net/blog/
Loading...