PostgreSQL and run a script to create users

CREATE USER tester WITH PASSWORD tester
  DEFAULT   TABLESPACE PMD_TABLESPACE
  TEMPORARY TABLESPACE TEMP
  QUOTA UNLIMITED ON PMD_TABLESPACE;
 
GRANT CONNECT             TO tester;
GRANT DELETE ANY TABLE    TO tester;
GRANT CREATE ANY TABLE    TO tester;
GRANT CREATE SEQUENCE     TO tester;
GRANT CREATE TRIGGER      TO tester;
GRANT SELECT ANY TABLE    TO tester;
GRANT SELECT ANY SEQUENCE TO tester;
  
-- ^^^^^^^^ PMD application user (tester2) ^^^^^^^^^
CREATE USER tester2 WITH PASSWORD tester
  DEFAULT   TABLESPACE PMD_TABLESPACE
  TEMPORARY TABLESPACE TEMP;
 
GRANT CONNECT             TO tester2;
GRANT SELECT ANY TABLE    TO tester2;
GRANT SELECT ANY SEQUENCE TO tester2;
 
-- ^^^^^^^^ PMD application user (tester3) ^^^^^^^^^^
CREATE USER tester3 WITH PASSWORD tester
  DEFAULT   TABLESPACE PMD_TABLESPACE
  TEMPORARY TABLESPACE TEMP;
 
GRANT CONNECT             TO tester3;
GRANT SELECT ANY TABLE    TO tester3;
GRANT SELECT ANY SEQUENCE TO tester3;
 
-- ^^^^^^^^ SA schema owner and user (tester4) ^^^^^^^^
CREATE USER tester4 WITH PASSWORD tester
  DEFAULT   TABLESPACE tester4
  TEMPORARY TABLESPACE TEMP
  QUOTA UNLIMITED ON tester4;
 
GRANT CREATE SESSION      TO tester4;
GRANT CONNECT             TO tester4;
GRANT CREATE ANY TABLE    TO tester4;
GRANT CREATE ANY SEQUENCE TO tester4;
GRANT SELECT ANY TABLE    TO tester4;
GRANT SELECT ANY SEQUENCE TO tester4;
 
-- ^^^^^^^ TM schema owner and user (repuser) ^^^^^^^
CREATE USER repuser WITH PASSWORD tester
  DEFAULT   TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  QUOTA UNLIMITED ON USERS;
 
GRANT CONNECT             TO repuser;
GRANT CREATE ANY TABLE    TO repuser;
GRANT DELETE ANY TABLE    TO repuser;
GRANT CREATE ANY SEQUENCE TO repuser;
GRANT SELECT ANY TABLE    TO repuser;
GRANT SELECT ANY SEQUENCE TO repuser;
 
 
-- =====================================================================================================
--                     Create triggers (Note: these are not table specific)
-- =====================================================================================================
 
-- ^^^^^^^^ Create trigger to change tester2's default schema to point to tester's schema ^^^^^^^^
CREATE OR REPLACE TRIGGER tester2.after_logon_trg
AFTER LOGON ON tester2.SCHEMA
BEGIN
  DBMS_APPLICATION_INFO.set_module(USER, 'Initialized');
  EXECUTE IMMEDIATE 'ALTER SESSION SET current_schema=tester';
END;
/
 
 
-- ^^^^^^^^ Create trigger to change tester3's default schema to point to tester's schema ^^^^^^^^
CREATE OR REPLACE TRIGGER tester3.after_logon_trg
AFTER LOGON ON tester3.SCHEMA
BEGIN
  DBMS_APPLICATION_INFO.set_module(USER, 'Initialized');
  EXECUTE IMMEDIATE 'ALTER SESSION SET current_schema=tester';
END;
/

                                  

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80: