Create PostgreSQL user and give permissions to objects in database

gistfile1.txt

SELECT set_config('current.user', 'my_user', false);
SELECT set_config('current.dbname', 'my_database', false);

CREATE USER current_setting('current.user');
  
-- Give CREATE, CONNECT, TEMPORARY permissions
GRANT ALL PRIVILEGES ON DATABASE current_setting('current.dbname') TO current_setting('current.user');
  
-- Grant INSERT, UPDATE, DELETE access to all EXISTING tables in public schema
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO current_setting('current.user');
-- Grant INSERT, UPDATE, DELETE access to all NEW tables in public schema
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT INSERT, UPDATE, DELETE ON TABLES TO current_setting('current.user');

--GRANT SELECT, USAGE access to all EXISTING sequences in public schema
GRANT SELECT, USAGE ON ALL SEQUENCES IN SCHEMA public TO current_setting('current.user');
--GRANT SELECT, USAGE access to all NEW sequences in public schema
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, USAGE ON SEQUENCES TO current_setting('current.user');

-- Note EXECUTE on functions is granted by default on the public schema