Part 13- PostgreSQL user and role Management

[@anandakumarsanthinathan4740]

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.

[@EMultiSkillsDatabaseServices]

Glad it was helpful!

[@andelakshmipathi2389]

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

[@ajaypandit9288]

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

[@EMultiSkillsDatabaseServices]

Hello Ajay, thank you find it helpful.

[@krishnachaitanya1000]

very useful and practical oriented, thanks for the video.

[@gregoryplaza]

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

[@EMultiSkillsDatabaseServices]

Thank you for finding it useful.

[@cimplyllc]

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

[@EMultiSkillsDatabaseServices]

Glad it was helpful!

[@sushmash7552]

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.

[@CodeNorthEast]

Very well explained.

[@EMultiSkillsDatabaseServices]

Thank you .

[@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?

[@EMultiSkillsDatabaseServices]

That's the usage of alter

[@MuhammadIlham-vn5nq]

thank you, I learned a lot

[@EMultiSkillsDatabaseServices]

Hello Muhammad, I am glad it helped you.

[@ashoksk7922]

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?

[@prathameshyadav8456]

How can we get privileges of roles only not the user

[@adityajajpure35]

There is no details about groups?

[@ricardohincapie1537]

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

[@EMultiSkillsDatabaseServices]

Thank you for the naming convention.

[@dhartipatel814]

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

[@EMultiSkillsDatabaseServices]

Create master role and assign it to individual users

[@tendupadala5090]

Super

[@galaxiegalaxie5003]

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

[@EMultiSkillsDatabaseServices]

Hello , I will surely be making a video tutorial on that . Thanks for your interest on that . I will make a note and respond hopefully

[@pankajholariya8331]

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

[@EMultiSkillsDatabaseServices]

Could you specify some details about it ?

[@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? :)

[@sarathkumarps6473]

Hi,did you got any reference regarding this

[@inclinedscorpio]

@@sarathkumarps6473 Hi, just create a new user, the new user won't be able to do modification unless you give the privilege.

[@sarathkumarps6473]

@@inclinedscorpio Thanks for your reply

[@karikalacholan1406]

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

[@EMultiSkillsDatabaseServices]

Yes, possible

[@juvettemunji7984]

thanks for the great knowledge

[@EMultiSkillsDatabaseServices]

My pleasure

[@azn_ryux]

Thenks for vidio I have need tis

[@EMultiSkillsDatabaseServices]

??

[@johnlug9655]

AWESOME series (bad ordering, but fixed here and on last one #27)
Part1: ua-cam.com/video/lkN_cFx5O1s/v-deo.html
Part2: ua-cam.com/video/lkN_cFx5O1s/v-deo.html

[@amanjain6680]

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

[@EMultiSkillsDatabaseServices]

will upload a new video for same.

[@rajkishoreshaw596]

great

[@munnashiva1509]

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

[@EMultiSkillsDatabaseServices]

Thank you for finding it useful.

[@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.

[@EMultiSkillsDatabaseServices]

Thanks for the tip!

[@naheliegend5222]

I don't still got how to create a new user a give him a maybe read_only permission.

[@EMultiSkillsDatabaseServices]

Read_only on what , may be I will try to write it for you

[@naheliegend5222]

@@EMultiSkillsDatabaseServices on data in the database obv

[@EMultiSkillsDatabaseServices]

Are they tables or everything in the database