diff options
| author | Donald Sarratt <donald.sarratt@nzx.com> | 2017-11-09 11:40:43 +1300 |
|---|---|---|
| committer | Donald Sarratt <donald.sarratt@nzx.com> | 2017-11-09 11:40:43 +1300 |
| commit | 7fe9275e2a5031b316f5242eb9645d02a69ea0dd (patch) | |
| tree | e7be9360b0f0e87e72a1fd9facd37db7e2e0eea1 | |
| parent | 8a7a86bf5db5ef7518c9e221912cc6edba4b8675 (diff) | |
| download | yoyo-7fe9275e2a5031b316f5242eb9645d02a69ea0dd.tar.gz | |
Refine oracle list_tables_sql to ignore tables owned by other users.
| -rw-r--r-- | yoyo/backends.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/yoyo/backends.py b/yoyo/backends.py index 2ff5aa5..2bab91e 100644 --- a/yoyo/backends.py +++ b/yoyo/backends.py @@ -387,7 +387,7 @@ class ODBCBackend(DatabaseBackend): class OracleBackend(DatabaseBackend): driver_module = 'cx_Oracle' - list_tables_sql = 'SELECT table_name FROM all_tables' + list_tables_sql = 'SELECT table_name FROM all_tables WHERE owner=user' def begin(self): """Oracle is always in a transaction, and has no "BEGIN" statement.""" |