Postgres Role based permissions

perms.sql

-- create user:
CREATE COLE user_name LOGIN PASSWORD 'password' SUPERUSER;

-- create role:
CREATE ROLE overlord;

-- grant role to user:
GRANT overlord TO user_name;

-- Not very many privs
GRANT SELECT ON ALL TABLES IN SCHEMA zz_test1 TO test2;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA zz_test1 TO test2;
GRANT USAGE ON SCHEMA zz_test1 TO test2;

-- muchos privs
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA zz_test1 TO test1;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA zz_test1 TO test1;
GRANT ALL ON SCHEMA zz_test1 TO test1;

CREATE ROLE

not

CREATE COLE