I have installed oracle 19.3 and can access the dual table from the sys user:
However I am not able to access the dual table from the other users having all privileges.
if sys.dual is used the username does get access to the dual table.
If anyone can suggest what is wrong.
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 1 Column: 15
