set echo off
--
--  grants_select.sql
--
--  Privileges - Grants select privilege for all tables in the current user/schema login for the specified user or role
--
--  Usage: @grants_select user
--
set termout off
set verify off
set doc off
set feedback off
set recsep off
set pagesize 0
--
define lsize=200
set linesize &&lsize
--
define out_file=grants_select.ddl
spool &&out_file
--
define input_role=&&1
--
SELECT 'GRANT SELECT ON '|| rtrim(OBJECT_NAME)||' to &&input_role;'
FROM user_objects
where object_type = 'TABLE' ;
SELECT 'GRANT SELECT ON '||
rtrim(OBJECT_NAME)||' to &&input_role;'
FROM USER_OBJECTS
where object_type IN ('VIEW','SEQUENCE');
--
spool off
set doc off
set feedback on
set pagesize 30
set termout on
set echo on
start &&out_file
-- exit