#!/bin/sh
#
# $DBA/allprivs
#
# Displays the direct grants for a specific database
#
echo ""
echo "Lists all direct grants made to all users and roles, segregated by"
echo "the nature of the grant."
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/allprivs
mv allprivs.lst allprivs.lis
#
#     Display or PRINT/DELETE the report file
#
echo ""
ls -al allprivs.lis
#lp -c allprivs.lis
#rm allprivs.lis