Plsql error
Hi,
Is this syntax wrong?
SQL> BEGIN
2 FOR Rec IN (SELECT object_name, object_type FROM DBA_objects WHERE owner='SYSFS' AND object_type IN ('TABLE','VIEW')) LOOP
IF Rec.object_type IN ('TABLE','VIEW') THEN
3 4 EXECUTE IMMEDIATE 'GRANT SELECT, UPDATE, INSERT, DELETE ON SOURCEUSER.'||Rec.object_name||' TO 834147';
5 END IF;
6 END LOOP;
7 END;
8 /
BEGIN
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 4
Regards,