Check out example codes for "postgresql grant all privileges on database". It will help you in understanding the concepts better.

Code Example 1

GRANT ALL PRIVILEGES ON dbname TO username;

Code Example 2

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username;

Code Example 3

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA schema_name TO username;

Learn ReactJs, React Native from akashmittal.com