I have one table granted with SELECT - so I can access the table with select..
I can also create copy of this table with:
CREATE TABLE my_table AS
SELECT *
FROM read_only_tbl;
And also manualy reloadtable ->
DELETE FROM my_table;
INSERT INTO my_table
SELECT *
FROM read_only_tbl;
But when I want to run the "reload" from procedure it gives me an error while compiling that the procedure can't see the "read_only_table"...
CREATE OR REPLACE PROCEDURE prcd_reload AS
BEGIN
DELETE FROM my_table;
INSERT INTO my_table
SELECT *
FROM read_only_tbl;
/*** .. rest of code ***/
END;
/
-> PL/SQL: ORA-00942: table or view does not exist
what grant do I need to access that table in procedure?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire