---
description: Create database, user and grant permissions
created: 2023-12-21
---

## Create database, and user for login

```bash
sudo -u postgres psql
```

```sql
CREATE DATABASE "database_name";
CREATE ROLE "username";
ALTER ROLE "username" WITH LOGIN;
ALTER USER "username" WITH PASSWORD 'change_me';
GRANT SELECT ON "table_name" TO "username";
```

> Replace `database_name`, `username`, `change_me` and `talbe_name`

## DB backup / restore