Example:
Code: Select all
dbadmin=> create table public.test (col1 int);
CREATE TABLE
dbadmin=> create user test_user;
CREATE USER
dbadmin=> grant insert, update on public.test to test_user;
GRANT PRIVILEGE
dbadmin=> \z public.test;
Access privileges for database "dbadmin"
Grantee | Grantor | Privileges | Schema | Name
-----------+---------+-------------------------------------------------+--------+------
dbadmin | dbadmin | INSERT*, SELECT*, UPDATE*, DELETE*, REFERENCES* | public | test
test_user | dbadmin | INSERT, UPDATE | public | test
(2 rows)