As you can see in picture 1 the ID "sys" have SYSDBA permission , I use it to connect the oracle , the filtered table as the picture 2 seems are system table , right ? ( as all tables names are ended with $ )
I am wonder why this sysdba ID do not have the permission to view the tables we created e.g filetable ( as picture 2 ) , is it because this ID do not have permission to select all table ? if yes , how can I allow the ID have permission to view all tables ( includes filetable ) ?
Besides , this sys account have FULL privileges of the oracle or not ? I tried to use the below command to grant privileges to user but not work, the error as below .
SQL> grant SELECT on filetable to user
grant SELECT on filetable to user
*
ERROR at line 1:
ORA-00942: table or view does not exist
Thanks