Please check this document to manage users using the extension. Details in this blog explained clearly. https://medium.com/@wasiualhasib/streamlining-postgresql-access-control-with-the-manage-user-permissions-extension-5a0e98096197
or go to github document.