SQL

postgresql change user role grant

=# ALTER USER librarian WITH SUPERUSER;
ALTER ROLE

grant create table privileges to user in postgres

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

postgresql grant alter table to user

#must be owner of table your_table

postgresql change user role grant

=# ALTER USER role_specification WITH OPTION1 OPTION2 OPTION3;