Database Priviliges

* PostgreSQL users can grant and revoke permissions to use or modify their database data from other users.

* The SQL commands GRANT and REVOKE are used for this purpose.

* For example:

As user postgres:

test=> REVOKE INSERT ON employees FROM shlomi \g
CHANGE
test=> REVOKE DELETE ON employees FROM shlomi \g
CHANGE
test=> REVOKE UPDATE ON employees FROM shlomi \g
CHANGE

Those commands made the table employees read-only for the user shlomi.

Now:

test=> GRANT INSERT ON employees TO shlomi \g
CHANGE

has given shlomi the permission to insert records into this table. (but not modify its existing contents or delete records).