that's the problem. The ID logs thru the application and uses another role (ABC) to o/p those tables.
But logging going thru the backend, the ID is tagged with another role which do not have SELECT. I can set SELECT for once so ID can do SELECT. However, as the tables are dropped and recreated, i cannot be performing the GRANT SELECT "automatically" or on the fly.
Is there a command that i can always set GRANT for the IDs (assume its role is VIEW) where tables are o/p by ROLE=ABC?