Very clear on the user and role concept. Great job.

Simply and clearly explained. Thanks.

Good explanation! Helped a lot to figure out. Keep going on and posting more useful videos, good luck!

Thanks for this video! It helped me a lot and was explained with easy examples. As a PostgreSQL beginner, it's not always easy to understand the basics of the underlying security. (Even if I know some other relational database server.)

Very usefull video. Thank you !

Superb, Thank You !! 🙏😊👍

crystal clear -- thanks

Very useful sir, thanks you

Nice. I have one query, I have created a new database (DB1) and new user(User1), Now i want to provide the DB OWNER access to DB1 for this new user (User1), Please guide on this.

Someone know if i could restring the exportation of a shapefile in qgis from pgadmin?

if we grant the create schema , that user can truncate and drop access ? even we didn't grant for drop.

How about this error while testing same as you said psql: error: FATAL: Peer authentication failed for user "user1"