privs drop after alter table

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: privs drop after alter table
Date: 2012-05-03 18:14:25
Message-ID: 0AD01C53605506449BA127FB8B99E5E10C37E452@FMSMSX105.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

v8.3.4 on linux

After this..
alter table fred alter column wilma set default 'dino';

...it appeared that a user that had insert,delete,update privs lost them.
I regranded and things went back to normal.

Is it correct for those privs to be dropped in this case? If so, why (just curious).

Thanks in Advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2012-05-03 18:25:15 Re: Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2
Previous Message Darren Duncan 2012-05-03 17:21:27 Re: Uppercase to lowercase trigger?