Script Completo - Permissão nas Tabelas via DBSCHEMA - Informix

Script Completo - Permissão nas Tabelas via DBSCHEMA - Informix

Script completo;

# -----------------------------------------------------------------------------------------------#
# Funcao : Ver as permissoes dos usuarios;                                                       #  
# Autor  : Claudemar Martins de Sa                                                               #
# Data   : 10/06/2014                                                                            #
# -----------------------------------------------------------------------------------------------#
clear

Principal () {

echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo "                                         $(hostname) - $(whoami)"
echo
echo "        Code  Function                                    "
echo "        ----  ------------------------------------------- "
echo "         1    Relatorio de Grants de Usuario              "
echo "         2    Relatorio de Revoke de Usuario              "
echo "         3    Relatorio de Tabela por Usuarios            "
echo "         0    Sair da Aplicacao                           "
echo "        ----  ------------------------------------------- "
echo
echo -n "     Digite um Codigo - "   
   read OPCAO2
   case $OPCAO2 in
      1) OPCAO_00000 ;;
      2) OPCAO_00001 ;;
      3) OPCAO_00002 ;;
      4) OPCAO_00003 ;;
      0) exit ;;
      *) clear ; Principal ;; 
   esac
}  

# ======================================================================================================
# ======================================================================================================

OPCAO_00000 () 
{

LOG1="/tmp/usuarios_com_acesso_no_banco_1234_pode_deletar_1234_1.log"
LOG2="/tmp/usuarios_com_acesso_no_banco_1234_pode_deletar_1234_2.log"

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
echo -n "Digite o USERNAME do USUARIO ........:  "
read USUARIO
echo
echo -n "Digite o NOME DO BANDO DE DADOS .....:  "
read DATABASE

dbschema -d $DATABASE -p $USUARIO | grep -E 'connect|grant' | grep -vE 'DBSCHEMA|language' > $LOG1 


clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
cat $LOG1

# rm $LOG1
# rm $LOG2



echo 
echo -n "Pressione qualquer tecla para continuar..."
read MSG
clear
Principal
}

# ======================================================================================================
# ======================================================================================================
# ======================================================================================================        

OPCAO_00001 () 
{

LOG1="/tmp/usuarios_com_acesso_no_banco_1234_pode_deletar_1234_1.log"

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
echo -n "Digite o USERNAME do USUARIO ........:  "
read USUARIO
echo
echo -n "Digite o NOME DO BANDO DE DADOS .....:  "
read DATABASE

dbschema -d $DATABASE -p $USUARIO > $LOG1 

sed -i 's/grant/revoke/' $LOG1
#sed -i 's/grant update on /revoke update on /' $LOG1
#sed -i 's/grant insert on /revoke insert on /' $LOG1
#sed -i 's/grant delete on /revoke delete on /' $LOG1
#sed -i 's/grant select on /revoke select on /' $LOG1
#sed -i 's/grant update on /revoke update on /' $LOG1
#sed -i 's/grant index on /revoke index on /' $LOG1
sed -i 's/ to / from /' $LOG1

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
cat $LOG1 | grep 'revoke' | grep -vE 'language|DBSCHEMA'

rm $LOG1

echo 
echo -n "Pressione qualquer tecla para continuar..."
read MSG
clear
Principal
}         

# ======================================================================================================
# ======================================================================================================

OPCAO_00002 () 
{

LOG1="/tmp/usuarios_com_acesso_no_banco_1234_pode_deletar_1234_1.log"
LOG2="/tmp/usuarios_com_acesso_no_banco_1234_pode_deletar_1234_2.log"

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
echo -n "Digite o nome da TABELA .............:  "
read TABELA
echo
echo -n "Digite o NOME DO BANDO DE DADOS .....:  "
read DATABASE

# dbschema -d $DATABASE -t $TABELA | grep -E 'grant' | grep -vE 'DBSCHEMA'  > $LOG1 
dbschema -d $DATABASE -t $TABELA -p all | grep -E ' on ' | grep -vE 'DBSCHEMA|revoke|create'  > $LOG1                      

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
cat $LOG1

rm $LOG1

echo 
echo -n "Pressione qualquer tecla para continuar..."
read MSG
clear
Principal
}

# ======================================================================================================
# ======================================================================================================

Principal