3 ms·

So you have different queries per access level/role? Like userProducts, managerProducts, supportProducts, adminProducts...?

• CuriouslyC 2y ago
  Yep, if the products table had columns that were only accessible to some users, SELECT * would throw an error in those cases.
  • throwaway11460 2y ago
    In my case I use Postgraphile. If you select a column that you can't access, you get an error - I don't see a problem there. PostgREST doesn't support column selection?
    • SahAssar 2y ago
      It does, but if you `SELECT *` and you don't have access to all the columns you will get an error. You need to select columns that you have access to and if you select all columns but don't have access to all columns you get an error. I think it's the same in Postgraphile, no?