Hands-On Serverless Applications with Kotlin

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.