- Setup Database
create database [db-name];
revoke all on schema public from public;
create schema [schema-name];
create table [schema-name].[table-name](
...
)
- Create Read-only User
create user [user-name] password '[password]';
grant usage on schema [schema-name] to [user-name];
alter user [user-name] set search_path to [schema-name];
grant select on table [schema-name].[table-name] to [user-name];
I don't think it is necessar
alter user [user-name] set search_path to [schema-name];