ALTER USER user1 CREATEDB;
GRANT privilege_list | ALL ON table_name TO role_name; Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)