Grants when objects are dropped and recreated
Hi
We created a read only user in our DB and granted a select on materialized view.
When we run a demantra program this particular object gets dropped and recreated and hence privileges are lost.
We also do not want to grant select any table for this one particular case.
Is there a workaround or trick which can be used to overcome this situation
Thanks
Hari