How To Grant Access Privileges To Db2 Table Using Sqlalchemy In A Jupyter Notebook

I've followed several examples to create and drop a DB2 table using SQLAlchemy within a python jupyter notebook. That works fine. But after creating the table, I need to set privil

Solution 1:

Maybe connected with transaction isolation, try explicit transaction control before/after the grant/revoke, or configure for autocommit

with engine.connect() as con:
    con.execute('COMMIT')
    con.execute('GRANT ALL ON MYSCHEMA.MYTABLE TO PUBLIC')
    con.execute('COMMIT')

Works for me on Db2-LUW on-premises.