Is there a way to grant permissions on any new objects (or at least new
tables) to a role?
In my app I have a function that drops and recreates a table at certain
times (with a different structure). Like a temporary table, but it
survives until a process is run which overwrites it. The process is not
the same user as the user who wants to view the table.
As soon as this happens the users lose rights to the table and I need to
manually run:
Grant select on NEWTABLE for users;
Thanks
Sim