Read-only user

You can create a role that provides read-only access to your database.

Important

Adding a read-only user role to your database does not provide resource isolation. If you want to restrict the access of a read-only user, as well as isolate resources, you can create a read replica instead. For more information, see the read scaling section.

Create a read-only user

You can create a read-only user to provide limited access to your database.

Creating a read-only user

Connect to your database as the tsdbadmin user.
At the psql prompt, create the new role:
```
CREATE ROLE readaccess;
```
Grant the appropriate permissions for the role, as required. For example, to grant SELECT permissions to a specific table, use:
```
GRANT SELECT ON <TABLE_NAME> TO readaccess;
```
To grant SELECT permissions to all tables in a specific schema, use:
```
GRANT SELECT ON ALL TABLES IN SCHEMA <SCHEMA_NAME> TO readaccess;
```

Create a new user:


CREATE USER read_user WITH PASSWORD 'read_password';

Assign the role to the new user:
```
GRANT readaccess TO read_user;
```

Read-only user

Important

Create a read-only user

Creating a read-only user

Related Content