Create a user : Create User « User Previliege « PostgreSQL






Create a user


-- 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;

           
       








Related examples in the same category