Create a user : Create User « User Previliege « PostgreSQL

1. PostgreSQL
2. User Previliege
3. Create User

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