May 2018
Intermediate to advanced
576 pages
30h 25m
English
There is no requirement in PostgreSQL to have some privileges in order to have others. This means that you may well have write-only tables, where you are allowed to insert but you can't select. This can be used to implement a mail-queue-like functionality, where several users post messages to one user, but they can't see what other users have posted.
Alternatively, you could set up a situation where you can write a record, but you can't change or delete it. This is useful for auditing log type tables, where all changes are recorded, but cannot be tampered with.