1 2 Previous Next 22 Replies Latest reply: May 1, 2014 3:39 AM by yoonas RSS

    Not able to see objects from apps schema in R12

    mksadmin

      Hi Guys,

       

      we are unable to get the objects from apps schema in R12 (12.1.3).

      When we execute the following query from apps schema. It just keep on running and not giving user prompt.

      I have done VALIDATE APPS SCHEMA and GRANT/RECREATE SYNONYM from adadmin.

      Could you please provide the solution.

      Below is the query which am executing.

       

       

       

      SELECT NULL, u1.owner, u1.object_name, u1.object_type, NULL

          FROM all_objects u1, role_tab_privs rtp, all_tab_privs atp

         WHERE u1.object_type IN ('TABLE', 'VIEW', 'SYNONYM')

           AND u1.object_name LIKE '%' /* Type selection : can be empty */

           AND u1.owner = rtp.owner(+)

           AND u1.object_name = rtp.table_name(+)

           AND u1.owner = atp.grantee(+)

           AND 'SELECT' = atp.PRIVILEGE(+)

           AND u1.object_name = atp.table_name(+)

           AND u1.owner = 'APPS' /* Owner selection : can be empty */

      UNION

      SELECT   NULL, asy.owner, asy.synonym_name, 'SYNONYM', NULL

          FROM all_synonyms asy

         WHERE asy.synonym_name LIKE '%' /* Type selection : can be empty */

           AND asy.owner = 'APPS' /* Synonym Owner selection : can be empty */

      ORDER BY 4, 2, 3

       

      Thanks in advance

        1 2 Previous Next