Dear All,
I have two schemas and i created select grant access on a view of Schema1 to schema2.
The objects(tables, views etc, everything ) in Schema1 are automatically created by application and not any user will touch them.
(Grant was given by us, though).
However, after sometime the grant access is being revoked(i.e., unable to access the view from Schema2). If we manually execute grant statement, again it is working.
What might be the reason?
Is it that the view is getting dropped and getting created again in Schema1(We don't know that, bcz it is from application)
or are there any reasons on why this happens?(Any similar situations you guys faced).
Kindly help on how to resolve this issue.
P.S: There is no grant on the baseline tables, which i think is not necessary