[Support Tip] Why there is an “ORA-00942: table or view does not exist” error while launching build even the view does exist?

0 Likes

Q: “ORA-00942: table or view does not exist” error occurs to below SQL when launching build:

DBIO: ACTUAL SQL
  SELECT
       A.AREA_ID,
       ND.LOGNODE_NAME
    FROM
       cm_typical.AREA_CATALOGUE A,
       PCMS_SYS.LOGICAL_NET_NODES ND
    WHERE
           AREA_UID = :I1
       AND A.NETWORKNODE_UID = LOGNODE_UID

But the SQL could be executed without problem if running it in the DB client directly with a system user(not cm_typical).

A: It may be caused by a permission issue that cm_typical user does not have grant select access to that pcms_sys view.

     Please try below CMD to give the grant permission :

C:\>dmdba system/manager@dim14

SYSTEM> grant_pcms_sys cm_typical

Labels:

Support Tip
Comment List
Related
Recommended