Configuring an application user

Once the master user has logged in to the database via the psql command-line utility, create a user named LetsPoll, as follows:

letsPoll=> CREATE USER letsPoll WITH PASSWORD '........';

Once the LetsPoll user has been created, grant all privileges to that user, as follows:

letsPoll=> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO letsPoll;GRANT
Granting all privileges to a user is not desirable in production environments very often. This step has to be exhaustively reviewed by a database administrator. For the purpose and scope of this chapter, we'll go ahead with this configuration.

Get Hands-On Serverless Applications with Kotlin now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.