psycopg2 не создаёт логины

import psycopg2
import random
 
def randPasw():
 pas = ''
 for x in range(8):  # Количество символов (16)
  pas = pas + random.choice(
   list('1234567890abcdefghigklmnopqrstuvyxwzABCDEFGHIGKLMNOPQRSTUVYXWZ'))
 return pas
 
host = "127.0.0.1"
user = "postgres"
password = "123456789"
db_name = "my_db"
 
def zapr(z):
 try:
  connection = psycopg2.connect(host=host, user=user, password=password, database=db_name)
 
  with connection.cursor() as cursor:
   cursor.execute(
    z
   )
   if "SELECT" in z.upper():
    a = cursor.fetchall()
    print(a)
    return a
   else:
    print(z)
 
 
 
 except Exception as _ex:
  print(_ex)
 finally:
  if connection:
   connection.close()
   print("ok\n")
 
 
 
 
notUsers = zapr("""
SELECT email
FROM Staff FULL OUTER JOIN pg_shadow on staff.email=pg_shadow.usename
WHERE pg_shadow.usename IS NULL
""") #[('alexeevD@gmail.com',), ('alexeevAl@gmail.com',), ('BizonovArs@gmail.com',), ('VarStas@gmail.com',), ('DubolAlex@gmail.com',), ('ElkaVict@gmail.com',), ('Jevakin@gmail.com',), ('jelud@gmail.com',), ('jeludOs@gmail.com',), ('zinovka@gmail.com',), ('zubar@gmail.com',), ('isaev@gmail.com',), ('kalitka@gmail.com',), ('kandratev@gmail.com',)]
 
depts_mans = zapr("""
SELECT email
FROM staff INNER JOIN depts_managers ON staff.id = depts_managers.manager_id
""") #[('alexeevD@gmail.com',), ('alexeevAl@gmail.com',), ('VarStas@gmail.com',), ('BizonovArs@gmail.com',)]
 
subdepts_mans = zapr("""
SELECT email
FROM staff INNER JOIN subdepts_managers ON staff.id = subdepts_managers.manager_id
""") #[('alexeevD@gmail.com',), ('jeludOs@gmail.com',), ('zinovka@gmail.com',), ('alexeevAl@gmail.com',), ('BizonovArs@gmail.com',), ('ElkaVict@gmail.com',), ('Jevakin@gmail.com',)]
 
 
list_nU = [str(*i) for i in notUsers]
list_dM = [str(*j) for j in depts_mans]
list_sdM = [str(*j) for j in subdepts_mans]
 
 
tmp = ''
# print('staff - ',list_nU)
for i in list_nU:
 pas = randPasw()
 if i in list_dM:
  tmp += (f'{i} - {pas}\n')
  zapr(f"""
  CREATE ROLE "{i}" WITH
    LOGIN
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE
    INHERIT
    NOREPLICATION
    CONNECTION LIMIT -1
    PASSWORD '{pas}';
GRANT dept_manager TO "{i}";
  """)
 elif i in list_sdM:
  tmp += (f'{i} - {pas}\n')
  zapr(f"""
    CREATE ROLE "{i}" WITH
    LOGIN
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE
    INHERIT
    NOREPLICATION
    CONNECTION LIMIT -1
    PASSWORD '{pas}';
GRANT sdept_manager TO "{i}";
    """)
 else:
  tmp += (f'{i} - {pas}\n')
  zapr(f"""
  CREATE ROLE "{i}" WITH
    LOGIN
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE
    INHERIT
    NOREPLICATION
    CONNECTION LIMIT -1
    PASSWORD '{pas}';
  GRANT staff TO "{i}";
      """)
 
file = open('new_txt','w')
file.writelines(tmp)
file.close()