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
- Identity: a dedicated user or role with
SELECTonly. - Objects: grants on the views you choose, not on tables.
- Session: a read-only transaction and a statement timeout.
- 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.