Glossary

What is read-only access?

Last updated

Definition

Read-only access means a connection can read data but cannot insert, update, delete or otherwise change it, so a tool that uses it cannot damage the data it analyzes.

Why it matters

An AI tool that can write is a risk. A read-only identity makes the worst case a wrong answer, not a changed table.

Layers of read-only

  1. Identity: a dedicated user or role with SELECT only.
  2. Objects: grants on the views you choose, not on tables.
  3. Session: a read-only transaction and a statement timeout.
  4. Network: an allowlist of the tool's addresses.

exelens applies the first three and tells you how to set the fourth. Details in get warehouse credentials and for Postgres. Book a demo.

Frequently asked questions

Is a read-only user enough?
Combine it with views only. Granting SELECT on specific views, not tables, limits what an analytics tool can even see.
How do I check it?
Inspect the grants for the user. exelens also tests the connection and warns if it finds write privileges.

See Read-only access in practice

A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.