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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
