oracle_grant_schema.sql

SELECT
    'grant '||DECODE(object_type,'TABLE','select,insert,delete,update ','VIEW',
    'select,insert,delete,update ','SEQUENCE','SELECT ','PROCEDURE','EXECUTE ','PACKAGE','EXECUTE '
    ,'TRIGGER','EXECUTE ','FUNCTION','EXECUTE ')|| ' on '||owner||'.'||object_name||
    ' to xpappusr;'
FROM
    dba_objects
WHERE
    OWNER='ODMT'
AND object_type IN ('TABLE',
                        'VIEW',
                        'PROCEDURE',
                        'FUNCTION');