Create roles affect the max connection param? I mean, the default is 100, if a create 100 users eventually I will need to increase max connections? thanks mr conger
3 are reserved for super users, but you can always use connection pooling and have more connection actually. Actually you can set how many connections super user connections are set. Be aware that you need available connections for replication if you have some advanced configuration of servers
Hello, good video, however, how can it be done so that the new role can only connect to the assigned database and does not have the other databases? Can it be done with REVOKE CONNECT? .. regards.
Generally, any privileges which are not explicitly granted are denied. Although a user can see the other databases in pgAdmin, unless they have explicit connect permissions, they will not be able to connect. They will get permission denied. I do not know how to make it so that they can't see the other databases, though there may be a way.
@@mohanreddy4875the role has to be able to login. You can alter the role in pgAdmin to add login and password. The role also has to have permissions to use the database and Schema.
Great video! I'm glad you kept the errors because that actually teaches us about issues we'll likely run ourselves.
I could feel love and warmth in his words. It is so good to learn and explore together. Thank you, Steve Conger.
The mistakes you make often teaches us better.
Create roles affect the max connection param? I mean, the default is 100, if a create 100 users eventually I will need to increase max connections? thanks mr conger
3 are reserved for super users, but you can always use connection pooling and have more connection actually.
Actually you can set how many connections super user connections are set.
Be aware that you need available connections for replication if you have some advanced configuration of servers
So good.
Hello, good video, however, how can it be done so that the new role can only connect to the assigned database and does not have the other databases? Can it be done with REVOKE CONNECT? .. regards.
Generally, any privileges which are not explicitly granted are denied. Although a user can see the other databases in pgAdmin, unless they have explicit connect permissions, they will not be able to connect. They will get permission denied. I do not know how to make it so that they can't see the other databases, though there may be a way.
how to grant permisons for the users to access the tables to update
GRANT UPDATE ON person TO employeerole.
Use the table name and role names that are relevant
@@SteveConger but when i try connecting with the user name it is been displayed as permission denied
@@mohanreddy4875the role has to be able to login. You can alter the role in pgAdmin to add login and password. The role also has to have permissions to use the database and Schema.
@@SteveConger thanks for sharing your knowledge will try and come back to you