PostgreSQL Tutorial 11 -- Creating User and Granting, Revoking permissions in postgresql

Below are the commands to 
Create User
Grant Permission
Revoke Permission
Listing Users
Drop User  
                      in Postgresql. 


1. Creating User: 
 

2. Granting Privilege:

3. Revoking Privilege: 

4. Listing the Users:

5. Dropping the users: 

Note: until we remove the all the privileges on the user, we can't remove the users. 












What is the difference between the these 2 statements. 

CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';

create user george with password 'password'; 

2. How to find the list of privileges for a user in postgresql?.