Retool's resource permissions: When a user is granted 'Use' access to a database resource

💬 Account & User Management
1

Current plan level is Business

Question / Description:

Regarding Retool's resource permissions: When a user is granted 'Use' access to a database resource (e.g., SQL database), what are the specific capabilities and limitations of this permission level? Specifically:

  1. Can users with 'Use' access write and execute their own custom SQL queries directly against the database?

  2. Are they restricted to only interacting with the database through pre-built Retool apps that contain predefined queries?

Thank you,

Best Regards,
Kanin

2

Hi @Kanin_Amornratanasiri ,

Users with Use permissions can run queries in prebuilt apps and view results in apps. However, they are not allowed to write or modify custom SQL queries directly or create new queries on that resource within the query editor.

If you want a user to be able to write custom SQL, you’ll need to grant them Edit access on both the app and the resource.

See the documentation here.