Cannot read LOV: FRM 40502

What could be the reason of the forms error 40502 (Oracle 8.1.7)?

Synonyms and grants are ok (through roles).
R_KloostermanAsked:
Who is Participating?
 
joelpattConnect With a Mentor dbaCommented:
This sounds like what I said above.  However, your last comment is ambiguous.  Was the solution to set the role for the person whose role was not set?  Or was it to grant the privileges explicitly to that person?

P.S. The problems not solved until the paperwork is done...  you should close out the question by selecting a winner.  Please let us know what you did in your comment.
0
 
Helena Markováprogrammer-analystCommented:
You can see underlying ORA-xxxx error by using
Display Error. Display Error can be accessed from the default Oracle Forms Runform Help menu, or by pressing the <Display Error> key.
0
 
R_KloostermanAuthor Commented:
The error is table or view does not exist. The used tables have synonyms and the grantings are correct (through roles and grantings).
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Mark GeerlingsDatabase AdministratorCommented:
If the form works for some users (like a DBA or the schema owner) then there is obviously a synonym or grant problem.  If it returns this error regardless of the user, then it is an error in the select statement in the form definition, or someone dropped or renamed a table (or view) after the form was last re-compiled.
0
 
joelpattdbaCommented:
I suspect that is if the schema owner can run it, the grants may have to be explicit and not through a role.  This could be because you are using objects accessed from the Form.  
0
 
R_KloostermanAuthor Commented:
I've checked the grants and synonyms. They are all present and correct. Every used table is still present. A co-worker also checked it. Everybody has the same problem. Might this be a bug?
0
 
R_KloostermanAuthor Commented:
I've checked the grants and synonyms. They are all present and correct. Every used table is still present. A co-worker also checked it. Everybody has the same problem. Might this be a bug?
0
 
R_KloostermanAuthor Commented:
I've checked the grants and synonyms. They are all present and correct. Every used table is still present. A co-worker also checked it. Everybody has the same problem. Might this be a bug?
0
 
FBIAGENTCommented:
R_KLOOSTERMAN,
If I were you, I would cut the query of the Record Group from which the LOV is based, and paste the query in SQL*Plus and see if you would get the same error message.  You should be able to go from there.
Good luck
0
 
R_KloostermanAuthor Commented:
Helle FBI-Agent, I did this, but not in the environment where the problem occurs.

Meanwhile I discovered the following. Both users are granted for the used tables through roles. One of them also has direct grants on one of the used tables, which the other user doesn't have.

The first user does not have the problem.
0
 
R_KloostermanAuthor Commented:
The problem is solved. The role was not set. One person het direct grants for all tables, the other didn't.
0
 
R_KloostermanAuthor Commented:
The person was granted for the role, but the role was not set. So it was not what you suggested. None of the users was schema owner and all of them had the correct role. Some people also had explicit grants for all used tables and therefore did not experience the problem when the role was not set. Others did not have all explicit grants and therefore experienced the problem.

All the above suggestions I checked myself and therefore there is no "winner". The only thing I did not check, was wether the role was set. That is why I am still thinking how to close the question.
0
 
joelpattdbaCommented:
I don't see why you would need both explicit grants and a set role.

Your said:  "Some people also had explicit grants for all used tables and therefore did not experience the problem when the role was not set".

This makes sense since they have all of the grants.

Then you said:  "Others did not have all explicit grants and therefore experienced the problem".  [experienced the problem when the role was not set].

So did you grant the remainder of the grants, or simply set the role?  

If you granted the remainder of the grants, I may still be correct.  If you can revoke all the grants and it still works only with the role, then it was simply that the role was not set.

I don't think you need both a role and explicit grants, it should be one or another especially for the purposes of administering privileges and users.  (I have seen roles with no privileges that the form checks for access, however in this case the role wasn't more than a key word, that if granted would allow passage).



0
 
R_KloostermanAuthor Commented:
the explicit grants are obsolete. It was used in the past, but they are not yet revoked.

Since we don't work with explicit roles anymore, we set the role.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.