ORA-00942: table or view does not exist.
More precisely it should give a text like
table or view does not exist or you are not allowed to access it.
For an ordinary user/schema separation there might be no big difference: If user A can not read table B.TAB it's of no value for user A whether the object does not exist or is just not accessible. But from a security point of view it might be of some interest if there exists a particular object within the database. Even it's not exploitable yet, maybe it's worth to try to reach it, or there is a combined vector of attack together with other objects.
To gain information about a system which should be kept hidden a well known method for physical cryptosystems is the side channel attack. At this attack extra information about the system is gained by measuring external channels like timings, power consumption and so on.
I am showing a similar method to get many informations about objects within a database a user should not know in general.
The described attack combines 2 well known concepts of every Oracle database: row cache and session statistics.
The row rache (or data dictionary cache) ... is a collection of database tables and views containing reference information about the database, its structures, and its users. - It's important to know this cache is filled by SQL-statements against the data dictionary tables.
session statistics just increase a counter for every session every time an action is executed.
Now let's check if we can get some hidden information out of my test system.
I did a
alter system flush shared_pool;to make it slightly easier for the testcase, but even with a pre-filled row cache I am sure these informations can get collected with only little more effort.
My measurement query is
select ms.sid, ms.statistic#, sn.name, ms.value from v$mystat ms, V$STATNAME sn where sn.name in ('recursive calls', 'execute count') and ms.statistic# = sn.statistic# order by 2;with a result like
SID STATISTIC# NAME VALUE ---------- ---------- -------------------- ---------- 221 9 recursive calls 3108 221 588 execute count 947
Now let's see where we can go. Something easy for the beginning. A select from a table which does not exist:
SQL> select * from gfdsaqwert; select * from gfdsaqwert * ERROR at line 1: ORA-00942: table or view does not existwith the measurement
SID STATISTIC# NAME VALUE ---------- ---------- -------------------- ---------- 221 9 recursive calls 3111 221 588 execute count 950this means, there where 3 recursive calls and 3 execute counts.
Now for something more interesting - let's check if a user exists:
SQL> select * from zzz.uztrfghj; select * from zzz.uztrfghj * ERROR at line 1: ORA-00942: table or view does not exist20 recursive calls
3 execute count
SQL> select * from a.uztrfghj; select * from a.uztrfghj * ERROR at line 1: ORA-00942: table or view does not exist21 recursive calls
3 execute count
In my test-DB no user ZZZ exists, but a user A exists. (but no table A.UZTRFGHJ) There is one more recursive call if the user exists. Not much, but a difference.
SQL> select * from a.m ; select * from a.m * ERROR at line 1: ORA-00942: table or view does not exist26 recursive calls
7 execute count
Now there are even more recursive calls and execute count. The Table A.M exists in my system.
I'd say this shows the concept. The official answer from the database was
ORA-00942: table or view does not existall the time. But v$mystat gave us some more information we did not get officially.