Security

Create your table in a dedicated schema and grant access to a minimally privlaged user.

Below, we’ll create a new user, ‘minuser’ with only the required permissions for the table ‘mytable’.

CREATE ROLE minuser with PASSWORD 'password';

Grant Connect on the database

GRANT CONNECT ON DATABASE mydb TO minuser;

Grant SELECT, INSERT, and UPDATE on table ‘mytable’

GRANT SELECT, INSERT, UPDATE ON mytable TO minuser;