def METHOD_NAME(request, conn_cnx):
    with conn_cnx() as cnx:
        cnx.cursor().execute("use role securityadmin")
        cnx.cursor().execute(
            "create or replace user magicuser1 password='xxx' " "default_role='PUBLIC'"
        )
        cnx.cursor().execute(
            "create or replace user magicuser2 password='xxx' " "default_role='PUBLIC'"
        )
    yield conn_cnx
    with conn_cnx() as cnx:
        cnx.cursor().execute("use role accountadmin")
        cnx.cursor().execute("drop user magicuser1")
        cnx.cursor().execute("drop user magicuser2")