来自
MySQL而不知道ROLE,我不曾试过这个
原文链接：https://www.f2er.com/postgresql/191784.htmlGRANT CREATE ON TABLESPACE pg_default TO username;
它没有预期的效果.我正在寻找的命令是：
ALTER ROLE username WITH CREATEDB;
但是有什么区别呢？给某人CREATEDB角色隐含地给他们创建了TABLESPACE …？有没有可以看到这一切的桌子？
从docs,GRANT CREATE ON TABLESPACE意味着(我的重点)：
For tablespaces,allows tables,
indexes,and temporary files to be
created within the tablespace,and
allows databases to be
created that have the
tablespace as their default
tablespace. (Note that revoking this
privilege will not alter the placement
of existing objects.)
