Part 13- PostgreSQL user and role Management

( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************

***********************************************************************************************
PostgreSQL support starting from 100 USD/Hr ( 24*7)
***********************************************************************************************

[anandakumarsanthinathan]

Very, very insightful. Manuals and docs only talk about how to create schemas, databases, roles, etc. How to effectively use them is something that is usually never taught. Your tutorial does it for us. Thank you very much.

[andelakshmipathi]

Great video this what I am looking from 1 year onwards good content in your explanation

[krishnachaitanya]

very useful and practical oriented, thanks for the video.

[ajaypandit]

Thanks a ton Sir for wonderful video. It's very helpful for me. Thanks once again.

[gregoryplaza]

thanks, Sr this is a very helpful video, with good explanations and examples. good job

[cimplyllc]

This is a good video and well explained. Appreciate the content.

[sushmash]

How can we create a user in postgres db with read-only access where he should only able to select the data in tables present in a DB but not create, alter, delete, update, drop the tables ( IN PUBLIC SCHEMA ). Can you please tell on how we can do it.

[galaxiegalaxie]

Thank you for the video, its very helpful, could you also do the video about indepth database design😁

[johnlug]

AWESOME series (bad ordering, but fixed here and on last one #27)

[ricardohincapie]

Very good. I would suggest a better naming of roles to facilitate following the great lecture you gave us. app_readonly1 and app_readwrite1 may be called role_read and role_write_read or something like that...

[ashoksk]

How to assign multiple users to a group, which is having set of roles. I have created a table with user column and password column and imported from excel file to the table. And Created a group and assigned multiple roles. Now how can I assign all users from user table to this group. Could you please provide any suggestion?

[prathameshyadav]

How can we get privileges of roles only not the user

[munnashiva]

Thank you so much for sharing the wonderful content. Just a request from my side... Can we also get the docs please.

[inclinedscorpio]

Hi! Thanks! I have a doubt. I created role with CRUD privileges and a new user and assigned role to the user. How can I revoke the modify table privileges? I don't want the user to run Alter or Drop commands. Only CRUD operations must be used. Any idea? :)

[pankajholariya]

how to make Create, Read, Update role but restrict to drop anything .


pls help sir

[dhartipatel]

hello sir, how can we automate this process for same roles with different users?

[amanjain]

How to setup linux environment? Sorry, not comp sci person, but need to know

[raypanjaitan]

17:39 Why do you have to alter the default privileges?
even thou on the second last query, you already granted select on all tables access.

Edit:
It's actually on every created role. Why do you have alter the privileges when you previously already granted them the privileges?

[karikalacholan]

Hi sir, 1 doubt.. my requirement is below
1. Create a read-only user "abc" in a Database
2. Create another user "efg" on same DB and "efg" should have privilege to change the password of user "abc"

Is this possible? Please advise a solution for this

[ernie_hudds]

You need to edit the video so you don't have you navigating through different software, closing down windows etc - helps keep focus on your content and keeps attention from viewer. Good video though.