PostgreSQL how to create user via createuser utility
Colleagues hello to all.
In today's article, we'll talk about how to create users in a PostgreSQL database using the createuser utility. In PostgreSQL, you can create a large number of users, and usernames must consist of letters and numbers.
Article content:
- Create a user using the createuser utility.
1. Creating a user using the createuser utility.
1.1. Creating a simple database user.
$. createuser inzhener --login --pwprompt
1.2. Create a user and assign him the right to create databases.
$. createuser inzhener --createdb --pwprompt
1.3. Create a user and assign him the right to create users in the database.
$. createuser inzhener --createrole --pwprompt
1.4. Create a super user.
$. createuser inzhener --superuser --pwprompt
1.5. Create a user and assign him the right to create backups and the ability to implement replication.
$. createuser inzhener --replication --pwprompt
Thank you all, I hope that my article helped you in some way.