create_sysdba.py

sql = ["""CREATE USER SYSDBA FROM DBC AS PERM=100000000000, SPOOL=40000000000, TEMPORARY=0, PASSWORD=sysdba;""",
       """MODIFY USER SYSDBA AS PASSWORD = sysdba;""",
       """GRANT SELECT,EXECUTE ON DBC TO SYSDBA WITH GRANT OPTION;""",
       """GRANT ALL ON SYSDBA TO SYSDBA WITH GRANT OPTION;""",
       """GRANT SELECT ON SYS_CALENDAR TO SYSDBA WITH GRANT OPTION;""",
       """GRANT SELECT ON DBC TO PUBLIC;""",
       """GRANT ROLE TO SYSDBA WITH GRANT OPTION;""", 
       """GRANT PROFILE TO SYSDBA WITH GRANT OPTION;""",
       """GRANT CREATE FUNCTION ON SYSDBA TO SYSDBA;""",
       """GRANT ALTER FUNCTION ON SYSDBA TO SYSDBA;""",
       """GRANT EXECUTE PROCEDURE ON SQLJ.REMOVE_JAR TO SYSDBA;""",
       """GRANT EXECUTE PROCEDURE ON SQLJ.INSTALL_JAR TO SYSDBA;""",
       """GRANT EXECUTE PROCEDURE ON SQLJ.REPLACE_JAR TO SYSDBA;""",
       """GRANT CREATE EXTERNAL PROCEDURE ON SYSDBA TO SYSDBA;""",
       """GRANT EXECUTE PROCEDURE ON VAL.td_analyze TO SYSDBA;""",
       """GRANT EXECUTE FUNCTION ON VAL.tda_dt_calc TO SYSDBA;""",
       """GRANT EXECUTE FUNCTION ON VAL.tda_kmeans TO SYSDBA;""",
       """GRANT SELECT ON VAL TO SYSDBA;""",
       """GRANT SELECT ON SYSDBA TO SYSDBA;""", 
       """GRANT CREATE TABLE on SYSDBA to SYSDBA;""",
       """GRANT EXECUTE FUNCTION on TD_SYSFNLIB.READ_NOS to SYSDBA;""",
       """GRANT EXECUTE FUNCTION on TD_SYSFNLIB.WRITE_NOS to SYSDBA;""",
       """GRANT CREATE AUTHORIZATION on SYSDBA to SYSDBA;""",
       """GRANT CREATE DATASET SCHEMA ON SYSUDTLIB TO SYSDBA;""",
       """GRANT CREATE FUNCTION ON SYSDBA to SYSDBA;""",
       """GRANT CREATE AUTHORIZATION on SYSDBA to SYSDBA;""", 
       """GRANT CREATE TABLE on SYSDBA to SYSDBA;""",
       """GRANT EXECUTE FUNCTION on TD_SYSFNLIB.READ_NOS to SYSDBA;""",
       """GRANT EXECUTE FUNCTION on TD_SYSFNLIB.WRITE_NOS to SYSDBA;""",
       """GRANT CREATE AUTHORIZATION on SYSDBA to SYSDBA;""",
       """GRANT CREATE DATASET SCHEMA ON SYSUDTLIB TO SYSDBA;""",
       """GRANT CREATE FUNCTION ON SYSDBA to SYSDBA;""",
       """GRANT CREATE AUTHORIZATION on SYSDBA to SYSDBA;""",
       """GRANT CREATE AUTHORIZATION on SYSDBA to SYSDBA;""",
       """SELECT USER SYSDBA;""",
       """GRANT EXECUTE, SELECT, INSERT, UPDATE, DELETE, STATISTICS, DUMP, RESTORE, CHECKPOINT, SHOW, EXECUTE PROCEDURE, ALTER PROCEDURE, EXECUTE FUNCTION, ALTER FUNCTION, ALTER EXTERNAL PROCEDURE, CREATE OWNER PROCEDURE, CREATE TABLE, CREATE VIEW, CREATE MACRO, CREATE DATABASE, CREATE TRIGGER, CREATE PROCEDURE, CREATE FUNCTION, CREATE EXTERNAL PROCEDURE, CREATE AUTHORIZATION, DROP TABLE, DROP VIEW, DROP MACRO, DROP DATABASE, DROP TRIGGER, DROP PROCEDURE, DROP FUNCTION, DROP AUTHORIZATION ON SYSDBA TO SYSDBA WITH GRANT OPTION;"""]


con = tdsql.connect(host=host, user=user, password=pw)
cur = con.cursor()
for s in sql:
    cur.execute(s)
    print(s)
    time.sleep(2)
con.close()