Creating a new user in the PostgreSQL database server
In every database server, there should be one database administrator and many user clients. The administrator creates new users and defines roles for each user. Once you have installed the PostgreSQL onto your computer, the super user administrator will have been automatically defined under the postgres username. Now, you can create a new user using the postgres account. In this recipe, you will create a new user and define its role.
Getting ready
It is always good to create a new user and log in using the new user to create a database. In that case, you will always be in a safe situation, and you can easily avoid accidental damage to your database server. In this recipe, you will create a new user, say testuser, with the following initial privilege:
- The new user can create a database
- The new user cannot create/modify the role of another user
How to do it…
To create a new user in the PostgreSQL database server, perform the following steps:
- Open...
