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>