Re: [GENERAL] default grant

2010-04-07 Thread Ing. Marcos Ortiz Valmaseda
Sim Zacks escribió: 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).

Re: [GENERAL] default grant

2010-04-07 Thread Sim Zacks
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 temporar

[GENERAL] default grant

2010-04-07 Thread Sim Zacks
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