Dropping User

Dropping the user :
    postgres=# drop user tesdb;

Drop role :
    postgres=# \du
                                    List of roles
    Role name |                         Attributes                         | Member of 
    -----------+------------------------------------------------------------+-----------
    postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
    tesdbuser | Superuser 

Changing Password :
    postgres=# alter user tesdbuser with password 'welcome to tesdb';

Alter role:
    alter user kri with password 'abcd' valid until '2024-01-19 10:15:00';


(Assigning privileges to role)