PostgreSQL/User Previliege/Create User
Create a user
<source lang="sql">
-- Create a PostgreSQL user (jor) in the accounting group that is valid until January 1, 2005 and -- has the specified password of jw1234. CREATE USER jor
WITH PASSWORD "jw1234" CREATEDB IN GROUP accounting VALID UNTIL "Jan 1 2005";
drop user jor;
</source>