rem
rem This script can be used to enable the Repository Browser to view and purge Error Tables
rem It grants 'select' and 'delete' privileges on the specified table to OWBSYS
rem
rem USAGE
rem This script must be run in the Schema that owns the Error Table
rem    
rem   @<OWB-HOME>/owb/rtp/sql/grant_error_table_privileges.sql <tablename>
rem
rem   tablename     :- e.g. TABLE1_ERR    - name of the Error Table
rem

set serveroutput on;
set verify off;

grant SELECT, DELETE on &1. to OWBSYS;