GRANT CONNECT ON DATABASE mydatabase TO myuser;
GRANT USAGE ON SCHEMA public TO myuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myuser;Danang Setya Pramana - Working Memory
This is my working memory when i forgot some command and some code for my work
GRANT CONNECT ON DATABASE mydatabase TO myuser;
GRANT USAGE ON SCHEMA public TO myuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myuser;