Re: Weird procedure access problem (ORA-00942)

"neilsolent" <n_at_solenttechnology.co.uk> a écrit dans le message de news: 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

The problem is at line 8 of the procedure.

Regards
Michel Received on Sat May 04 2013 - 09:51:53 CEST