Solved

Cannot read LOV: FRM 40502

Posted on 2001-08-22
15
4,441 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 34

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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now