ASSINGNING PRIVILEGES TO USER

 postgres=# create user tesdbuser login superuser password 'welcome';
CREATE ROLE
postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 tesdb     |                                                            | {}
 tesdbuser | Superuser