Solved

Cannot read LOV: FRM 40502

Posted on 2001-08-22
15
4,448 Views
Last Modified: 2008-07-16
What could be the reason of the forms error 40502 (Oracle 8.1.7)?

Synonyms and grants are ok (through roles).
0
Comment
Question by:R_Kloosterman
15 Comments
 
LVL 22

Expert Comment

by:Helena Marková
ID: 6412581
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
 

Author Comment

by:R_Kloosterman
ID: 6412763
The error is table or view does not exist. The used tables have synonyms and the grantings are correct (through roles and grantings).
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 6413811
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Expert Comment

by:joelpatt
ID: 6414954
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
 

Author Comment

by:R_Kloosterman
ID: 6415122
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
 

Author Comment

by:R_Kloosterman
ID: 6415126
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
 

Author Comment

by:R_Kloosterman
ID: 6415262
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
 
LVL 5

Expert Comment

by:FBIAGENT
ID: 6415893
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
 

Author Comment

by:R_Kloosterman
ID: 6416763
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
 

Author Comment

by:R_Kloosterman
ID: 6416927
The problem is solved. The role was not set. One person het direct grants for all tables, the other didn't.
0
 
LVL 1

Accepted Solution

by:
joelpatt earned 100 total points
ID: 6417100
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
 

Author Comment

by:R_Kloosterman
ID: 6417457
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
 
LVL 1

Expert Comment

by:joelpatt
ID: 6417712
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
 

Author Comment

by:R_Kloosterman
ID: 6417866
0
 

Author Comment

by:R_Kloosterman
ID: 6429123
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question