def METHOD_NAME(username, password, role_name, connection=_CONNECTION):
    update_credential(username, "pfoo1235", password, connection=connection)
    print(select_one_user(username, connection=connection))
    is_exception = False
    try:
        select_all_user(connection=connection)
    except Exception as e:
        print(e)
        is_exception = True
    assert is_exception
    role = Role(role_name, using=_CONNECTION)
    role.grant("User", "*", "SelectUser", db_name=_DB_NAME)
    print(select_all_user(connection))
    role.revoke("User", "*", "SelectUser", db_name=_DB_NAME)