10.Share a Product List

A partner shop connects as partner. It may see the name and price of products that are in stock, and nothing else.

Create a view public_products with the name and price of every product with stock above 0.
Let partner read the view, and not the products table.
Become partner and read every row of public_products.
Still as partner, look at the tabs. How many of them show "permission denied"?
Go back to your own role.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT * FROM products;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 50/5 done

Create the view
public_products, with name then price, for products with stock above 0.