# $DBA/colgrant
#
echo ""
echo "Lists all direct grants made against all columns of a specific table or"
echo "view, segregated by the nature of the grant recipient.  This report is"
echo "a complete listing of all methods by which the columns may be accessed."
echo "Used to research the potential impact of revokes against columns that"
echo "have multiple access paths that lead to it.\n\n"
echo "Enter the ORACLE SID of the database to be accessed: \c"
read sid
mysid=`fixcase $sid`
valid_db $mysid
if [ $? -ne 0 ]; then exit 2
fi
echo "Enter schema name which owns the table or view: \c"
read owner
echo "\nEnter name of a table or view in this schema: \c"
read tname
echo ""
SID=$mysid
. define
sqlplus -s / @$DBA/colgrant $mysid $owner $tname
mv colgrant.lst colgrant.lis
#
#     Display or PRINT/DELETE the report file
#
ls -al colgrant.lis
#lp -c colgrant.lis
#rm colgrant.lis