Chapter 7, Writing Stored Procedures, was all about stored procedures and writing server-side code. After introducing you to many important topics, it is now time to shift our focus to PostgreSQL security. You will learn how to secure a server and configure permissions.
The following topics will be covered:
- Configuring network access
- Managing authentication
- Handling users and roles
- Configuring database security
- Managing schemas, tables, and columns
- Row-level security
At the end of the chapter, you will be able to write good and efficient procedures.
