Tablespace permissions issue
От
Gavin Sherry
Тема
Tablespace permissions issue
Дата
Msg-id
Pine.LNX.4.58.0406281529570.16981@linuxworld.com.au
Список
Дерево обсуждения
Tablespace permissions issue Gavin Sherry <swm@linuxworld.com.au>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Fabien COELHO <coelho@cri.ensmp.fr>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Fabien COELHO <coelho@cri.ensmp.fr>
Re: Tablespace permissions issue Gavin Sherry <swm@linuxworld.com.au>
Chris KL just raised an issue on IRC:
test=> create table test (a int4) tablespace pg_default;
ERROR: permission denied for tablespace pg_default
This wasn't encountered in my original patch because
pg_tablespace_aclmask() had this test reasonably early on:
+ if(tbloid == DEFAULTTBLSPC)
+ return (mask);
I guess that might have been a bit presumptuous but a similar thing
happens if you don't specify a tablespace:
tablespaceId = get_namespace_tablespace(namespaceId); /* note no permission check on tablespace in this case */
What should the solution be?
Gavin
В списке pgsql-hackers по дате отправления