connect system/*****

CREATE OR REPLACE PROCEDURE aki_bank(deco IN VARCHAR2) is
BEGIN
UPDATE g.cl_c
set g_u = deco 
where code = '124568';
commit;
END;
/

Procedure created

begin
aki_bank('test333');
end;
PL/SQL procedure successfully completed

CREATE USER "INVENTOPER0101" IDENTIFIED BY "oper01"
 DEFAULT TABLESPACE USER
 TEMPORARY TABLESPACE TEMPORARY
 QUOTA 80M ON USER QUOTA 10M ON TEMPORARY
User created
 
GRANT CREATE SESSION TO "INVENTOPER0101"
Grant succeeded
 
GRANT "CONNECT" TO "INVENTOPER0101"
Grant succeeded

GRANT EXECUTE any procedure TO "INVENTOPER0101"
Grant succeeded

connect INVENTOPER0101/*****

select * from g.cl_c
ORA- 00942 : table does not exist
(это понятно гранта-то на эту таблицу INVENTOPER0101 не имеет!!!!)

begin
reg.aki_bank('testOper');
end;
PL/SQL procedure successfully completed

CREATE USER test LOGIN
  ENCRYPTED PASSWORD 'md505a671c66aefea124cc08b76ea6d30bb'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

GRANT EXECUTE ON FUNCTION editbp(IN int8, OUT cnumber "varchar"
........)
TO test;

SELECT * FROM editbp( 25 );

ERROR:  permission denied for relation budpasport

CREATE OR REPLACE FUNCTION editbp(IN int8, OUT cnumber "varchar", OUT ddatereestr date,....., OUT cvillname "varchar") AS
$BODY$
SELECT budpasport.cNumber, budpasport.dDatereestr, 
budpasport.cRishennyano, budpasport.dDaterishennya,
budpasport.dPaymentdate, budpasport.nPaymentsum, 
budpasport.nSquare, budpasport.nPrivNo,
budpasport.nExplNo, budpasport.nYearInExpl,
budpasport.cNote, budpasport.projectstypesid, 
budpasport.typebudid, budpasport.fioid, budpasport.houseadrid,
typebud.ctypname,
projectstypes.cprojectstypes,
TRIM(both ' ' from Fio.cSurname||' '||Fio.cName||' '||Fio.cFather) AS cFio,
Houses.cHouseno, Houses.Streetid, Streets.cStreetName, Streets.villid AS StrVilId,
Villages.cVillname
FROM budpasport, typebud, projectstypes, Fio, Houses, Streets, Villages 
WHERE budpasport.id = $ 1 
AND budpasport.typebudid = typebud.id
AND budpasport.projectstypesid = projectstypes.id
AND budpasport.fioid = Fio.id
AND Budpasport.Houseadrid = Houses.id 
AND Houses.Streetid = Streets.id
AND Streets.villid = Villages.id ;
$BODY$
  LANGUAGE 'sql' VOLATILE;
ALTER FUNCTION editbp(IN int8, OUT cnumber "varchar", OUT ddatereestr date,....., OUT cvillname "varchar") OWNER TO "system";
GRANT EXECUTE ON FUNCTION 

editbp(IN int8, OUT cnumber "varchar", OUT ddatereestr date,....., OUT cvillname "varchar") TO public;
GRANT EXECUTE ON FUNCTION 
editbp(IN int8, OUT cnumber "varchar", OUT ddatereestr date,....., OUT cvillname "varchar")  TO "system";
GRANT EXECUTE ON FUNCTION 
editbp(IN int8, OUT cnumber "varchar", OUT ddatereestr date,....., OUT cvillname "varchar")  TO test;

alter function editbp(...) security definer;

  Дальше пошли легкиЯ оффтопы....  пришлось  сделать монтаж ;-) 
  Не  обижайтесь -
  скучно  смотреть как вполне разумные люди вместо чтения доки пытаются доказать недоказуемое....    да еще и на арго. Легче уж  свистом общаться ;))

 WBR   Shweik