Create and manage role

Objectives:

  • using command line: pgAdminII.exe
  • creating role @ command line
  •  Modify the role using pgAdminIII.exe

Now using pgsql : password :postgre_manas9

CREATE ROLE manas237 LOGIN
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

Now add a password: user manas237 : password: pwmanas237

 

 

Note the changes in the

CREATE ROLE manas237 LOGIN
ENCRYPTED PASSWORD 'md5b14afbf9d130ffaf51501a1cd619ec3e'
NOSUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION VALID UNTIL '1969-12-31 00:00:00';