<p dir="auto"><strong>Describe the bug</strong><br>
SQLAlchemy 1.3.21 has broken some oracle db connections, specifically changes from <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="759903138" data-permission-text="Title is private" data-url="https://github.com/sqlalchemy/sqlalchemy/issues/5755" data-hovercard-type="issue" data-hovercard-url="/sqlalchemy/sqlalchemy/issues/5755/hovercard" href="https://github.com/sqlalchemy/sqlalchemy/issues/5755">#5755</a>. Same connection works correctly at &lt;= 1.3.20.</p>
<p dir="auto"><strong>Expected behavior</strong><br>
Running <code class="notranslate">engine.connect()</code> should succeed without error.</p>
<p dir="auto"><strong>To Reproduce</strong></p>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="from sqlalchemy import create_engine

conn_string = 'oracle+cx_oracle://USERNAME:PASSWORD@HOST:PORT?service_name=TNS'
engine = create_engine(conn_string)
engine.connect()"><pre class="notranslate"><span class="pl-k">from</span> <span class="pl-s1">sqlalchemy</span> <span class="pl-k">import</span> <span class="pl-s1">create_engine</span>

<span class="pl-s1">conn_string</span> <span class="pl-c1">=</span> <span class="pl-s">'oracle+cx_oracle://USERNAME:PASSWORD@HOST:PORT?service_name=TNS'</span>
<span class="pl-s1">engine</span> <span class="pl-c1">=</span> <span class="pl-en">create_engine</span>(<span class="pl-s1">conn_string</span>)
<span class="pl-s1">engine</span>.<span class="pl-en">connect</span>()</pre></div>
<p dir="auto"><strong>Error</strong></p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Traceback (most recent call last):
  File &quot;/opt/rh/rh-python38/root/usr/local/lib/python3.8/site-packages/coyotes/sql/db_conn.py&quot;, line 82, in create_sql_connection
    connection = engine.connect()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 2263, in connect
    return self._connection_cls(self, **kwargs)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 104, in __init__
    else engine.raw_connection()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 2369, in raw_connection
    return self._wrap_pool_connect(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 2339, in _wrap_pool_connect
    Connection._handle_dbapi_exception_noconnection(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 1583, in _handle_dbapi_exception_noconnection
    util.raise_(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/compat.py&quot;, line 182, in raise_
    raise exception
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py&quot;, line 2336, in _wrap_pool_connect
    return fn()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 304, in unique_connection
    return _ConnectionFairy._checkout(self)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 495, in checkout
    rec = pool._do_get()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py&quot;, line 140, in _do_get
    self._dec_overflow()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/langhelpers.py&quot;, line 68, in __exit__
    compat.raise_(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/compat.py&quot;, line 182, in raise_
    raise exception
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py&quot;, line 137, in _do_get
    return self._create_connection()
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 309, in _create_connection
    return _ConnectionRecord(self)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 440, in __init__
    self.__connect(first_connect_check=True)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py&quot;, line 664, in __connect
    pool.dispatch.first_connect.for_modify(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py&quot;, line 314, in exec_once_unless_exception
    self._exec_once_impl(True, *args, **kw)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py&quot;, line 285, in _exec_once_impl
    self(*args, **kw)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py&quot;, line 322, in __call__
    fn(*args, **kw)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/langhelpers.py&quot;, line 1406, in go
    return once_fn(*arg, **kw)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/strategies.py&quot;, line 199, in first_connect
    dialect.initialize(c)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py&quot;, line 921, in initialize
    super(OracleDialect_cx_oracle, self).initialize(connection)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/base.py&quot;, line 1320, in initialize
    super(OracleDialect, self).initialize(connection)
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/default.py&quot;, line 325, in initialize
    self.default_isolation_level = self.get_isolation_level(
  File &quot;/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py&quot;, line 956, in get_isolation_level
    cursor.execute(
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00942: table or view does not exist
(Background on this error at: http://sqlalche.me/e/13/4xp6)"><pre class="notranslate"><code class="notranslate">Traceback (most recent call last):
  File "/opt/rh/rh-python38/root/usr/local/lib/python3.8/site-packages/coyotes/sql/db_conn.py", line 82, in create_sql_connection
    connection = engine.connect()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 2263, in connect
    return self._connection_cls(self, **kwargs)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 104, in __init__
    else engine.raw_connection()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 2369, in raw_connection
    return self._wrap_pool_connect(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
    Connection._handle_dbapi_exception_noconnection(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
    util.raise_(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
    return fn()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
    rec = pool._do_get()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
    self._dec_overflow()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
    return self._create_connection()
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 664, in __connect
    pool.dispatch.first_connect.for_modify(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py", line 314, in exec_once_unless_exception
    self._exec_once_impl(True, *args, **kw)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py", line 285, in _exec_once_impl
    self(*args, **kw)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/event/attr.py", line 322, in __call__
    fn(*args, **kw)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 1406, in go
    return once_fn(*arg, **kw)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 199, in first_connect
    dialect.initialize(c)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 921, in initialize
    super(OracleDialect_cx_oracle, self).initialize(connection)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/base.py", line 1320, in initialize
    super(OracleDialect, self).initialize(connection)
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/default.py", line 325, in initialize
    self.default_isolation_level = self.get_isolation_level(
  File "/opt/rh/rh-python38/root/usr/local/lib64/python3.8/site-packages/sqlalchemy/dialects/oracle/cx_oracle.py", line 956, in get_isolation_level
    cursor.execute(
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00942: table or view does not exist
(Background on this error at: http://sqlalche.me/e/13/4xp6)
</code></pre></div>
<p dir="auto"><strong>Versions.</strong></p>
<ul dir="auto">
<li>OS: Windows 10, RHEL7 (docker), WSL</li>
<li>Python: 3.6.9, 3.8.3</li>
<li>SQLAlchemy: 1.3.<strong>21</strong></li>
<li>Database: oracle odbc</li>
<li>DBAPI: cx_oracle</li>
</ul>
<p dir="auto"><strong>Additional context</strong><br>
This is the only oracle odbc database I have access to, so I am unable to test other connections.</p>
<p dir="auto">Thanks!</p>
<p dir="auto"><strong>Describe the bug</strong><br>
By default, users do not have access to v$transaction. On startup all request will be fail.</p>
<p dir="auto">new in <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="759903138" data-permission-text="Title is private" data-url="https://github.com/sqlalchemy/sqlalchemy/issues/5755" data-hovercard-type="issue" data-hovercard-url="/sqlalchemy/sqlalchemy/issues/5755/hovercard" href="https://github.com/sqlalchemy/sqlalchemy/issues/5755">#5755</a></p>
<p dir="auto"><strong>Error</strong></p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="cx_Oracle.DatabaseError: ORA-00942: table or view does not exist"><pre class="notranslate"><code class="notranslate">cx_Oracle.DatabaseError: ORA-00942: table or view does not exist
</code></pre></div>
<p dir="auto"><strong>Versions.</strong></p>
<ul dir="auto">
<li>SQLAlchemy: 1.3.21</li>
<li>Database: Oracle</li>
<li>DBAPI: cx-Oracle-7.3.0</li>
</ul>