Re: Weird procedure access problem (ORA-00942)

From: Adrian <bulleid_at_ku.gro.lioff>
Date: Sat, 4 May 2013 18:53:30 +0100
Message-ID: <42O8KJBasUhRFwy6_at_ku.gro.lloiff>

In message
<a5d85760-f1ae-48d8-8481-f3bd0d76fa4f_at_r4g2000vbf.googlegroups.com>, neilsolent <n_at_solenttechnology.co.uk> writes
>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

I would guess that line 8 of your procedure is trying to access a table or view. Whilst SSF probably has the correct grants for that view, SSF_ADMIN1 probably doesn't. Give the grants explicitly to SSF_ADMIN1 and see what happens.

Adrian

-- 
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.

Received on Sat May 04 2013 - 19:53:30 CEST