#!/bin/sh
#
# $DBA/allgrant
#
# Displays the direct grants for a specific database
#
echo ""
echo "Lists all direct grants made against all tables, views, and programs,"
echo "segregated by the type of the grant recipient.  This report is a complete"
echo "listing of all methods by which all objects may be accessed.  Used to"
echo "research the potential impact of revokes against objects that have"
echo "multiple access paths that lead to it."
echo ""
echo "Enter the ORACLE SID of the database to be accessed: \c"
read sid
echo ""
mysid=`fixcase $sid`
valid_db $mysid
if [ $? -ne 0 ]; then exit 2
fi
SID=$mysid
. define
sqlplus -s / @$DBA/allgrant
mv allgrant.lst allgrant.lis
#
#     Display or PRINT/DELETE the report file
#
echo ""
ls -al allgrant.lis
#lp -c allgrant.lis
#rm allgrant.lis