External DB Permissions

hello.
I have successfully connect external DB using GCP’s mysql.

secret also
{
“collectionPermissions”: [
{
“id”: “Contacts”,
“read”: [“Admin”, “Member”],
“write”: [“Admin”, “Member”]
}
]
}

and environment variables have been added in cloud run as well. However, only admin is still able to read and write, members are not allowed to read and write.
Do i have any problem? or permission environ is not support yet?

Hello! Per the documentation:
“Customizing permissions for external databases is currently a developer preview feature, and may change. Changes to permissions settings are not reflected in the Wix Editor.”

I would reach out to customer support to get more information on the status.

How did you get to connect because I’m stuck at connecting EXTERNAL COLLECTIONS:

Could you help me finish making an EditorX EXTERNAL CONNECTIONS to a Google Cloud Platform MySQL database, from which I can connect with no problem with Dbeaver and MySQL Workbench (seeing the various databases and tables), have manage to get the three green sections , but I keep getting the errors connecting the collection, and getting the: You are missing the following required permissions: Project wix-velo-api containeranalysis.occurrences.list Would you have a clue on how to fix these two errors…? and how to get rid of all the bad/old EXTERNAL COLLECTION links?

Hi David Yang, I successful connected the GCP DB to WIX. What about sharing experiences on this topic directly since you’re starting to do it too?

I have this problem with the permissions, I already have everything connected, I can create new data, delete, edit, read, but I can’t connect the permissions, I follow the procedure established in the guide, but I can’t make the permissions status bar be green, if someone knows how to make the .json file that connects correctly with the collections and the permissions, I would appreciate it.