(cfg, eng, ident)
| 65 | |
| 66 | @create_db.for_db("oracle") |
| 67 | def _oracle_create_db(cfg, eng, ident): |
| 68 | # NOTE: make sure you've run "ALTER DATABASE default tablespace users" or |
| 69 | # similar, so that the default tablespace is not "system"; reflection will |
| 70 | # fail otherwise |
| 71 | with eng.begin() as conn: |
| 72 | conn.exec_driver_sql("create user %s identified by xe" % ident) |
| 73 | conn.exec_driver_sql("create user %s_ts1 identified by xe" % ident) |
| 74 | conn.exec_driver_sql("create user %s_ts2 identified by xe" % ident) |
| 75 | conn.exec_driver_sql("grant dba to %s" % (ident,)) |
| 76 | conn.exec_driver_sql("grant unlimited tablespace to %s" % ident) |
| 77 | conn.exec_driver_sql("grant unlimited tablespace to %s_ts1" % ident) |
| 78 | conn.exec_driver_sql("grant unlimited tablespace to %s_ts2" % ident) |
| 79 | # these are needed to create materialized views |
| 80 | conn.exec_driver_sql("grant create table to %s" % ident) |
| 81 | conn.exec_driver_sql("grant create table to %s_ts1" % ident) |
| 82 | conn.exec_driver_sql("grant create table to %s_ts2" % ident) |
| 83 | |
| 84 | |
| 85 | @configure_follower.for_db("oracle") |
nothing calls this directly
no test coverage detected