Weird procedure access problem (ORA-00942)

From: neilsolent <n_at_solenttechnology.co.uk>
Date: Sat, 4 May 2013 00:23:43 -0700 (PDT)
Message-ID: <a5d85760-f1ae-48d8-8481-f3bd0d76fa4f_at_r4g2000vbf.googlegroups.com>

Hi

User SSF can see and execute procedure SP_GET_SERVER, and has granted execute access to user SSF_ADMIN1. However (sqlplus session as SSF_ADMIN1): SQL> select * from all_objects where object_name = 'SP_GET_SERVER' and object_type = 'PROCEDURE';

OWNER                          OBJECT_NAME
------------------------------ ------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- --------------
-------------------
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
--------- --------- ------------------- ------- - - -
SSF                            SP_GET_SERVER
                                    12266                PROCEDURE

03-MAY-13 04-MAY-13 2013-05-04:07:57:06 VALID N N N SQL> var c refcursor;
SQL> exec SSF.SP_GET_SERVER(:c);
BEGIN SSF.SP_GET_SERVER(:c); END;

*
ERROR at line 1:

ORA-00942: table or view does not exist
ORA-06512: at "SSF.SP_GET_SERVER", line 8
ORA-06512: at line 1

What could be wrong here?

thanks - Neil Received on Sat May 04 2013 - 09:23:43 CEST