Part 13- PostgreSQL user and role Management

( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************
For Self Paced Learning: courses.emultiskills.com/cour... ( Paid one-time subscription )
Online Training: [e-mail] or wa.me/message/VUBG74XTU3DSM1
***********************************************************************************************
PostgreSQL support starting from 100 USD/Hr ( 24*7)
WhatsApp contact: wa.me/message/VUBG74XTU3DSM1
Email: [e-mail]
***********************************************************************************************

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

[@krishnachaitanya1000]

very useful and practical oriented, thanks for the video.

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

[@cimplyllc]

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

[@EMultiSkillsDatabaseServices]

Glad it was helpful!

[@gregoryplaza]

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

[@EMultiSkillsDatabaseServices]

Thank you for finding it useful.

[@MuhammadIlham-vn5nq]

thank you, I learned a lot

[@EMultiSkillsDatabaseServices]

Hello Muhammad, I am glad it helped you.

[@CodeNorthEast]

Very well explained.

[@EMultiSkillsDatabaseServices]

Thank you .

[@juvettemunji7984]

thanks for the great knowledge

[@EMultiSkillsDatabaseServices]

My pleasure

[@rajkishoreshaw596]

great

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

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

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

[@johnlug9655]

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

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

[@azn_ryux]

Thenks for vidio I have need tis

[@EMultiSkillsDatabaseServices]

??

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

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

[@adityajajpure35]

There is no details about groups?

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

[@pankajholariya8331]

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

[@EMultiSkillsDatabaseServices]

Could you specify some details about it ?

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

[@amanjain6680]

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

[@EMultiSkillsDatabaseServices]

will upload a new video for same.

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

[@simonearnshawuk]

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