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
>
>
>