I forgot to mention I'm using 8.2 On 4/7/2010 1:40 PM, Sim Zacks wrote: > 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
