Questions

1. Which configuration files need to be edited in order to allow a user to access the PostgreSQL from a remote machine using a password?
2. What are the authentication types supported by PostgreSQL?
3. Does the order of pg_hba.conf file entries matter?
4. When creating a table with a serial data type, which objects should be granted proper permissions?
5. List all the PostgreSQL access security levels.
6. What is the meaning of proxy authentication?
7. You need to allow a user to access only one set of rows of a table. Give two strategies to achieve this.
8. Why it is recommended to use the \password psql client toll?
9. What is the difference between one-way and two-way encryption?
10. What are the limitations of symmetric encryption? How can you overcome these limitations?