usql icon indicating copy to clipboard operation
usql copied to clipboard

Successully connecting but still getting error ORA-00942

Open 4r73m190r0s opened this issue 1 year ago • 1 comments

I successfully connect to my local Oracle Database XE 21c, to the default PDB called XEPDB1. But, every time I connect, I get an error

Connected with driver oracle (<unknown, error: oracle: ORA-00942: table or view does not exist>)

To connect, I'm using this command: usql oracle://<user>:<pass>@localhost/xepdb1

4r73m190r0s avatar Oct 18 '24 08:10 4r73m190r0s

I reproduced the same error by logging with a user that doesn't have read privilege on SYS.v$instance accessed by the Version function. PR #524 fixes this issue by reading the version from another view.

murfffi avatar May 02 '25 16:05 murfffi