how to implement user permissions code example

Example: create user and give permissions

CREATE USER sammy;
ALTER USER sammy WITH SUPERUSER;