call_grant_sel.sql

 

set echo off
prompt
prompt ================================================================================
prompt call_grant_sel.sql &1
prompt

set echo off pagesize 0 feedback off verify off serveroutput on size 1000000

define v_input_grantee       = &1

define v_grant_sel_work_file = ./log/grant_sel_work_file_&v_input_grantee..sql

--
-- construct the work file
--
spool &v_grant_sel_work_file
begin
  if ('&v_input_grantee' = '&v_na') then
    dbms_output.put_line('-- Skipping this user ...');
  else
    dbms_output.put_line('@gen_grant_sel &v_input_grantee');
  end if;
end;
/
spool off
--
-- call the work file
--

@&v_grant_sel_work_file