PostgreSQL roles, schema and security

In this video, I explain the concept of postgres roles, schema and manage security using them with demos.

[@youforfun100]

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

[@nikolozdolaberidze4652]

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

[@phyothiritun2109]

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

[@swapnilvmestry]

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.

[@mauricioiturbe4620]

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

[@rdeckard66]

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.)

[@Cult-Fan]

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

[@SachithSoorage]

Simply and clearly explained. Thanks.

[@alessandromortola8727]

Very useful sir, thanks you

[@VK-fr5mc]

Superb, Thank You !! 🙏😊👍

[@maxnoish]

Very usefull video. Thank you !

[@have2eat]

crystal clear -- thanks