Postgres: To drop a user

 REASSIGN OWNED BY username TO new_owner;

DROP OWNED BY username;

DROP USER username;

REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA ctlgadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA ctlgadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA ctlgadmin FROM pnm300;

  REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA ctlgadmin2 FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA ctlgadmin2 FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA ctlgadmin2 FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA ctlgadmin2 FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA ctlgadmin2 FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA ctlgadmin2 FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA cfaudit FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA cfaudit FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA cfaudit FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA cmsadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA cmsadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA cmsadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA cfadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA cfadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA cfadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA grpadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA grpadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA grpadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA invadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA invadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA invadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA seadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA seadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA seadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA ordadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA ordadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA ordadmin FROM pnm300;

 REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA cmtadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA cmtadmin FROM pnm300;

REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA cmtadmin FROM pnm300;

revoke usage on schema cfadmin from pnm300;

revoke usage on schema cmtadmin from pnm300;

revoke usage on schema ordadmin from pnm300;

revoke usage on schema invadmin from pnm300;

revoke usage on schema grpadmin from pnm300;

revoke usage on schema ctlgadmin from pnm300;

revoke usage on schema ctlgadmin2 from pnm300;

revoke usage on schema seadmin from pnm300;

revoke usage on schema cmsadmin from pnm300;

revoke usage on schema cfaudit from pnm300;

revoke connect on database cfprod from  pnm300;

DROP USER pnm300;