I recently downloaded odd 1.1c and installed it on a Linux machine. It seems to work if I log into the Oracle Database using ODD with a username which has administrative privileges. When I try to log into the Oracle database with ODD with a username which has no administrative privileges, I get the following error:
Could not parse:
SELECT '<a href=''index.php?module=tablespaces&name=' || tablespace_name || '''>' || TABLESPACE_NAME || '</a>' "Tablespace", TRUNC(SUM(TOT) / 1024) "Total space", TRUNC(SUM(FREE) / 1024) "Free space", CONCAT(TRUNC((SUM(FREE) / SUM(TOT)) * 100), '%') "Free perc" FROM ( SELECT TABLESPACE_NAME, BYTES / 1024 TOT, 0 FREE FROM DBA_DATA_FILES UNION ALL SELECT TABLESPACE_NAME, 0, BYTES / 1024 FROM DBA_FREE_SPACE ) GROUP BY TABLESPACE_NAME ORDER BY 2 DESC, 1
Error: ORA-00942: table or view does not exist
Can you please tell me how to solve this problem or is it a bug in ODD?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
ODD wasn't really meant to be used by end-users (i.e. users without dba rights). Most of the info shown is info about processes, sessions, etc. which isn't available without those dba rights.
The error messages could be friendlier though, I might be able to fix that in an upcoming release.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I recently downloaded odd 1.1c and installed it on a Linux machine. It seems to work if I log into the Oracle Database using ODD with a username which has administrative privileges. When I try to log into the Oracle database with ODD with a username which has no administrative privileges, I get the following error:
Could not parse:
SELECT '<a href=''index.php?module=tablespaces&name=' || tablespace_name || '''>' || TABLESPACE_NAME || '</a>' "Tablespace", TRUNC(SUM(TOT) / 1024) "Total space", TRUNC(SUM(FREE) / 1024) "Free space", CONCAT(TRUNC((SUM(FREE) / SUM(TOT)) * 100), '%') "Free perc" FROM ( SELECT TABLESPACE_NAME, BYTES / 1024 TOT, 0 FREE FROM DBA_DATA_FILES UNION ALL SELECT TABLESPACE_NAME, 0, BYTES / 1024 FROM DBA_FREE_SPACE ) GROUP BY TABLESPACE_NAME ORDER BY 2 DESC, 1
Error: ORA-00942: table or view does not exist
Can you please tell me how to solve this problem or is it a bug in ODD?
ODD wasn't really meant to be used by end-users (i.e. users without dba rights). Most of the info shown is info about processes, sessions, etc. which isn't available without those dba rights.
The error messages could be friendlier though, I might be able to fix that in an upcoming release.