fix(oracle): use view available for all users for driver.Version
Closes #489
Use v$version instead of v$instance because it is available to all users.
Like v$instance, v$version is available in all non-ancient oracle versions.
Both are available in the earliest documentation I could find: 10g, released 2003.
Testing Done: Oracle Express 21c (as in the reported issue) and 11g
For 11g:
docker run -d -p 1521:1521 -e ORACLE_PASSWORD=foobar gvenzl/oracle-xe:11-slim ./usql oracle://sys:foobar@localhost/xe
# version is shown correctly
create user test identified by test;
GRANT CREATE SESSION to test;
\connect oracle://test:test@localhost/xe
# version is still shown correctly, despite minimal privileges
21c in the issue was also tested that way.
合并状态:未合并 1 条评论