teableio / teable

✨ The Next Gen Airtable Alternative: No-Code Postgres
https://teable.io
GNU Affero General Public License v3.0
7.63k stars 307 forks source link

"You don't have permission to access the database" when trying to get DB connection info #594

Closed christophberger closed 1 month ago

christophberger commented 1 month ago

Describe the bug When I try to obtain database information via API > Postgres Connection, I get the error message "You don't have permission to access the database".

To Reproduce

  1. Go to a table
  2. Click on < / > API
  3. Select "Postgresql Connection"
  4. See error

Expected behavior DB connection info should appear

Screenshots

Screenshot 2024-05-07 at 23 44 20

Client (please complete the following information):

Platform (Please tell us which deployment version you are using) docker-standalone

Additional context I am able to access the database from DBeaver using the connection info in dockers/examples/standalone/.env. So I cannot see what permissions are missing.

tea-artist commented 1 month ago

Only users with creator permission can view and create db connections on the interface. You can check the permission registration of the current account in space. (and we will optimize this error message

christophberger commented 1 month ago

Thank you for explaining the reason. The point is, I have set up the docker standalone example by following the steps in the docs. I did not notice any advice about verifying or setting creator permissions. As the only user on the server, I would have expected to be a creator automatically.

I cannot find any permission settings at space level. How can I change the permissions to become creator?

tea-artist commented 1 month ago

You are right, you are already a creator, I just reproduced the problem, it is a bug