I currently have 2 circuits, A and B.
B has a table, and A performs insert and update choices on it.
In our sql scripts, we granted A permissions so that they can perform their tasks.
grant select on B.thetable to A
etc,etc
Now the table "table" is discarded, and the other table is renamed to B at least once a day.
rename someothertable to thetable
After that, we get an error message when A completes a selection on B.thetable.
ORA-00942: table or view does not exist
Is it possible that after drop + rename operations, grants will also be lost?
Do I need to assign permissions again?
Update
someothertable has no grants.
Update2
The daily process, which inserts data into the “table”, fixes each N attachments, so any rollback was not possible. That is why we use 2 tables.