Database Permissions Problem (feature request)

I am working on a site with a store. My client wants to have coupon codes for their customers which is easy enough and something they can manage with their app using the coupon feature under marketing.

What’s cool is this content is added to a database that is accessible in dev mode.

My client also wants to display the coupons on their site—which seems reasonable to me. So, I thought I was being smart and I created a repeater + dataset on a page that pulled the information from the coupons database.

This was going to be super snazzy and was going to be a useful way to display coupons in different contexts. However…I ran into a snag. I cannot change the read permissions to “everyone” with this database as it is locked on Admin. Therefore, nothing displays on the site.

All that to ask: Is it possible to allow us to change the read permissions on these databases or is this something the Wix developers could “turn on” for us?

Imagine what you could do. Not just coupons, but with products, etc.

P.S. I know that I could create a separate database and have my client add coupons there. BUT…my client isn’t really that smart and I would be getting calls every month and it would mean upkeeping both their coupons and a separate database. Not generally a good idea.

I asked the team for you:

You cannot change permissions in the built in databases. It is possible, however, to query the database using backend code when using suppressAuth: true in your query options. Keep in mind you will not be able to data bind the results data and will have to use code - but yes, it’s possible.

So…basically…for me, it’s not doable because I am very ignorant when it comes to code. :neutral_face:

@brett When the team says it’s not possible, does that mean forever, or currently?

It is doable. There are a lot of partners that can help you. I don’t believe it will be changeable, especially with the function that was built as a work around.