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
3 жыл бұрын
Glad it was helpful!
@andelakshmipathi2389
3 жыл бұрын
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.
@tendupadala5090
Күн бұрын
Super
@ajaypandit9288
3 жыл бұрын
Thanks a ton Sir for wonderful video. It's very helpful for me. Thanks once again.
@EMultiSkillsDatabaseServices
3 жыл бұрын
Hello Ajay, thank you find it helpful.
@CodeNorthEast
3 жыл бұрын
Very well explained.
@EMultiSkillsDatabaseServices
3 жыл бұрын
Thank you .
@gregoryplaza
2 жыл бұрын
thanks, Sr this is a very helpful video, with good explanations and examples. good job
@EMultiSkillsDatabaseServices
2 жыл бұрын
Thank you for finding it useful.
@raypanjaitan
10 ай бұрын
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
10 ай бұрын
That's the usage of alter
@cimplyllc
Жыл бұрын
This is a good video and well explained. Appreciate the content.
@EMultiSkillsDatabaseServices
Жыл бұрын
Glad it was helpful!
@rajkishoreshaw596
3 ай бұрын
great
@sushmash7552
2 жыл бұрын
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.
@ricardohincapie1537
3 жыл бұрын
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
3 жыл бұрын
Thank you for the naming convention.
@MuhammadIlham-vn5nq
3 жыл бұрын
thank you, I learned a lot
@EMultiSkillsDatabaseServices
3 жыл бұрын
Hello Muhammad, I am glad it helped you.
@ashoksk7922
2 жыл бұрын
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?
@galaxiegalaxie5003
3 жыл бұрын
Thank you for the video,its very helpful,could you also do the video about indepth database design😁
@EMultiSkillsDatabaseServices
3 жыл бұрын
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
@azn_ryux
2 жыл бұрын
Thenks for vidio I have need tis
@EMultiSkillsDatabaseServices
2 жыл бұрын
??
@johnlug9655
3 жыл бұрын
AWESOME series (bad ordering, but fixed here and on last one #27) Part1: kzitem.info/news/bejne/zaGExZd8sWeAZKg Part2: kzitem.info/news/bejne/zaGExZd8sWeAZKg
@juvettemunji7984
3 жыл бұрын
thanks for the great knowledge
@EMultiSkillsDatabaseServices
3 жыл бұрын
My pleasure
@prathameshyadav8456
2 жыл бұрын
How can we get privileges of roles only not the user
@adityajajpure35
11 ай бұрын
There is no details about groups?
@munnashiva1509
3 жыл бұрын
Thank you so much for sharing the wonderful content. Just a request from my side... Can we also get the docs please.
@EMultiSkillsDatabaseServices
3 жыл бұрын
Thank you for finding it useful.
@pankajholariya8331
3 жыл бұрын
how to make Create , Read , Update role but restrict to drop anything . pls help sir
@EMultiSkillsDatabaseServices
3 жыл бұрын
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
@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
@amanjain6680
3 жыл бұрын
How to setup linux environment? Sorry, not comp sci person, but need to know
@EMultiSkillsDatabaseServices
3 жыл бұрын
will upload a new video for same.
@inclinedscorpio
2 жыл бұрын
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
2 жыл бұрын
Hi,did you got any reference regarding this
@inclinedscorpio
2 жыл бұрын
@@sarathkumarps6473 Hi, just create a new user, the new user won't be able to do modification unless you give the privilege.
@sarathkumarps6473
2 жыл бұрын
@@inclinedscorpio Thanks for your reply
@ernie_hudds
3 жыл бұрын
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
3 жыл бұрын
Thanks for the tip!
@naheliegend5222
3 жыл бұрын
I don't still got how to create a new user a give him a maybe read_only permission.
@EMultiSkillsDatabaseServices
3 жыл бұрын
Read_only on what , may be I will try to write it for you
@naheliegend5222
3 жыл бұрын
@@EMultiSkillsDatabaseServices on data in the database obv
Пікірлер: 53