ckgrant.sql

REM *************************************************************************** 
REM 
REM        TITLE:
REM        AUTHOR:
REM        DESCRIPTION:
REM
REM
REM
REM        USAGE W/ PARAMETERS:
REM        
REM        TABLES USED:
REM
REM  MODIFICATION ALLOWED (Y/N):	
REM  MODIFICATION HISTORY:
REM  WHO          WHEN         WHAT
REM  --------------------------------------------------------------------------
REM               MM/DD/YY     INITIAL CREATION
REM
REM ***************************************************************************
set feedback off;
set head off;
set pagesize 0;
spool grants.sql
select 'grant select,update,insert,delete on '||
table_name||
' to '
||' &grantee '||';'
from sys.dba_tables
where owner = '&owner'
/