Solutionunvalidated
GRANT CONNECT ON DATABASE mydb TO userx; — GRANT USAGE ON SCHEMA public TO userx;. Tension: grant SELECT, INSERT, UPDATE, DELETE on all tables in schema public to userx;. Outcome: The user cannot create, modify, delete a database, a table or a column in a table.
62663c84-81a7-4591-8da9-a5b4e3e91209
GRANT CONNECT ON DATABASE mydb TO userx; — GRANT USAGE ON SCHEMA public TO userx;. Tension: grant SELECT, INSERT, UPDATE, DELETE on all tables in schema public to userx;. Outcome: The user cannot create, modify, delete a database, a table or a column in a table.