Skip to main content
Question

Invalid Table Name for Specific User

  • July 11, 2023
  • 1 reply
  • 154 views

Forum|alt.badge.img+1

i already customize frmMultiPaymentCustomer and added some column. When a specific user tries to load customer payment screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”. The user already has the permission set to the view. 

Does someone know how to resolve this issue?

Thanks & Regards,

Ninda

1 reply

Forum|alt.badge.img+7

Hi,

I do not have a straight solution for this but I have seen similar cases/errors when the SQL for the query has been erroneous. Maybe check that the table name is spelled correctly.

Also, if the query is a site/company specific it is always good to check that the specific person has the correct default site and company set before executing the query.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings