Does iDBQuery respect my own database login and its permissions?
Yes — iDBQuery connects using credentials you provide, so it inherits whatever that database account can and can't do. Give it a read-only, least-privilege login scoped to specific schemas or tables, and iDBQuery is bounded by exactly those permissions, on top of its own in-app role, row, and column controls.
iDBQuery's access to a source is never broader than the credentials you hand it, which gives you a familiar, database-level lever for control.
- Your credentials, your limits. Connect with a database user, and iDBQuery can only reach what that user can reach. If the account can't see a schema or a table, neither can iDBQuery.
- Least privilege by design. Best practice is a read-only account scoped to just the data you want analysed — a read replica, a reporting schema, a subset of tables — which caps iDBQuery's footprint at the source.
- Layered with app controls. On top of the database permissions, iDBQuery adds its own role-based access and row/column security, so you can further differentiate what individual users see within what the connection allows.
This two-layer model — your database's own permission system plus iDBQuery's — is reassuring when pointing an AI tool at real systems. It means you can reason about access using tools you already trust, and it complements deployment choices like VPC, Desktop, or air-gapped. Every query iDBQuery runs is visible and cited, so you can also confirm it only ever read within the boundaries its login permits.
Updated 2026-06-22
Related questions
- Does iDBQuery connect to my database with read-only access?
- How does iDBQuery handle row-level security and permissions?
- Can I hide or mask specific columns from certain users in iDBQuery?
- How does iDBQuery make sure it never writes to or deletes my data?
- How do I connect an on-prem database behind a firewall to iDBQuery?