#817 Tora queries SYS tables while the user cannot READ them
When Tora connects to an Oracle schema, the following error is raised:
ORA-00942: table or view does not exist
SELECT s.sid || ',' || s.serial# "Session",
s.username "User",
u.TABLESPACE "Tablespace",
u.segtype "Type",
substr ( a.sql_text,1,50 ) "SQL",
round ( u.blocks * p.value / :siz ,2 )||:sizstr "Size",
s.sql_address || ':' || s.sql_hash_value " "
FROM v$tempseg_usage u,
v$session s,
v$sqlarea a,
<ERROR>v$parameter p
WHERE s.saddr = u.session_addr
AND a.address ( + ) = s.sql_address
AND a.hash_value ( + ) = s.sql_hash_value
AND p.name = 'db_block_size'
Actually, the oracle user I am connecting to has no read access to the sys tables (v$...). This access cannot be granted because of the database security policy of my company.
It would be better if, when logging in, Tora could check wether it has read access or not on this tables, and if not, inhibits the features related to them.
Tora version: 2.1.2
Operating system: Windows XP
Oracle client version: 10
