sybSearch()
{
## changing current directory to that of the specified tree.
cd $TREE
cnt=`find ./ -name INSTALL\* -print -follow  2>/dev/null | wc -l | awk '{print $1}'`
if [ $cnt = 0 ]; then
        echo "\n============================================================================================" > $REPORT
        echo "There is no *INSTALL* file in this Package, please create one and resubmit your Package.." >> $REPORT
        echo "============================================================================================\n" >> $REPORT
        mailx -s "Scan Host: $HOST Tree: $TREE" "$MAILSTR" < $REPORT
        exit $VIOLATION
fi
## Preparing TEMP file
cat <<! > $TEMPSYB
[#]*use[#]*master[#]*$
[#]*use[#]*GDMGAdmin[#]*$
[#]*use[#]*GDMGSecurity[#]*$
[#]*use[#]*sybsecurity[#]*$
[#]*use[#]*sybsystemprocs[#]*$
[#]*use[#]*SEMSAuditDb[#]*$
sp_addlogin[#]*
sp_adduser[#]*
sp_addalias[#]*
sp_dropuser[#]*
sp_dropalias[#]*
sp_droplogin[#]*
sp_locklogin[#]*
sp_addgroup[#]*
sp_modifylogin[#]*
sp_changegroup[#]*
sp_addrole[#]*
sp_addrolemember[#]*
sp_droprole[#]*
^[#]*create[#]*role[#]*
^[#]*create[#]*database[#]*
[#]*grant.*to[#]*public[#]*
[#]*revoke.*from[#]*public[#]*
!
#[#]*grant.*to[#]*public[#]*$
#[#]*revoke.*from[#]*
###############################
#### Get list of all Tables
###############################
//g' | egrep -v '(.sh:|.ksh:)' | sed 's/^.*://g' | sed 's/^M//g' | grep -v '^[ /]*#' | egrep -i '(.dat|.ctl)' | sed -e 's/^.*=//g' -e 's/,/ /g' -e 's/;/ /g' -e 's/"//g' | tr ' ' '\n' | sed 's/[    ]*//g' | sed '/^$/d' | sort -u | awk -F"/" '{print $NF}' > $FILE
num_ctrl_files=0
OS=`uname`
if [ "$OS" = "SunOS" ]
then
//g' | egrep -v '(.sh:|.ksh:)' | sed 's/^.*://g' | sed 's/^M//g' | grep -v '^[ s]*#' | egrep -i '(.dat|.ctl)' | sed -e 's/^.*=//g' -e 's/,/ /g' -e 's/;/ /g' -e 's/"//g' | tr ' ' '\n' | sed 's/[    ]*//g' | sed '/^$/d' | sort -u | nawk -F"/" '{print $NF}' > $FILE
        num_ctrl_files=`wc -l $FILE | nawk '{print $1}'`
else
//g' | egrep -v '(.sh:|.ksh:)' | sed 's/^.*://g' | sed 's/^M//g' | grep -v '^[ s]*#' | egrep -i '(.dat|.ctl)' | sed -e 's/^.*=//g' -e 's/,/ /g' -e 's/;/ /g' -e 's/"//g' | tr ' ' '\n' | sed 's/[    ]*//g' | sed '/^$/d' | sort -u | awk -F"/" '{print $NF}' > $FILE
        num_ctrl_files=`wc -l $FILE | awk '{print $1}'`
fi