Answered
Cold fusion error
Hello,
We are using Cold Fusion 2018 on a windows server 2016.
When I try to access a cfm file I get an error, the details of which tell me that I do not have access to a table( dba_data_files) in a query that is being run. When I copied and pasted the same query in my SQL editor I do have access to the table with the same user which the cfm file is supposed to access. I have double checked the data sources in cfm admin page and also the System DSN all are looking to point to the same database and the user. So what could be wrong why am I getting this error ?
Thanks
IQ
Error Executing Database Query. | |
| [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist | |
| The error occurred in C:/inetpub/wwwroot/TOPS/admin/admin_datafiles.cfm: line 20 | |
18 : 19 : <cfif dbtype is 'oracle'> 20 : <cfquery name="Select2" datasource="#datasource#" UserName="#Session.UserName#" Password="#Session.Password#"> 21 : SELECT file_name, tablespace_name, bytes, blocks, status, autoextensible, maxbytes, maxblocks, increment_by from dba_data_files 22 : </cfquery> | |
AdChoices