PostgreSQL User Permissions

After a new user is added, if the user is allowed to access the database?

1. Add the configuration in HBA. config. If there is a general configuration, it does not need to be processed. For example, if the user item is "all"

2. The new user is not the database owner. Therefore, all objects must be granted permissions. Each table and view may cause trouble when there are more objects. You can consider writing a process. Note that public represents all users when configuring permissions.

3. after ownership of the database is moved to a new user, it is still inaccessible because although the database owner is a new user, the objects (such as tables) in the database do not change the owner at the same time, you also need to change the owner of all objects.