Owner of the table can't perform VACUUM because of lack of permissions on pg_aoseg schema

Products

• VMware Tanzu Greenplum

Issue/Introduction

When changing ownership of a table, VACUUM operation fails with permission denied for schema pg_aoseg.

This issue does not occur with GPDB 5.x:

gpadmin=# create table ttt1( id int) with (appendonly=true, orientation=column);
...
CREATE TABLE

gpadmin=# alter table ttt1 owner to ttt;
ALTER TABLE
gpadmin=# \q

[gpadmin@mdw_lab1 ~]$ psql -U ttt
gpadmin=> vacuum ttt1 ;
ERROR:  permission denied for schema pg_aoseg  (seg0 10.193.102.45:30580 pid=26264)

Environment

Product Version: 6.1

Resolution

This has been reported as a bug for GPDB 6.x.

Issue number is 30266 and should be included in GPDB 6.2.