#!/bin/bash # Version: 1.0.1 # Description: R_USER="username" SERVER_LIST=" SERVER-01 SERVER-02 SERVER-03 " cat <<\SQL_CREAT > SQLName.sql create user US_ISBT_SUPPORT identified by UserPassWord; GRANT CONNECT TO ADMIN_SUPPORT; GRANT RESOURCE TO ADMIN_SUPPORT; GRANT SELECT ANY TABLE TO ADMIN_SUPPORT; GRANT SELECT ANY DICTIONARY TO ADMIN_SUPPORT; GRANT SELECT_CATALOG_ROLE TO ADMIN_SUPPORT; alter user ADMIN_SUPPORT account lock; SQL_CREAT for R_SERVER in SERVER_LIST scp SQLName.sql [email protected]$R_SERVER:/tmp/ ssh [email protected]$R_SERVER 'chmod 777 /tmp/SQLName.sql' ssh -tt [email protected]$R_SERVER <<EOF sudo su - su - oracle sqlplus / as sysdba @/tmp/SQLName.sql exit exit exit EOF