#!/bin/sh
#
# $DBA/alltabp
#
# Displays the Table Privileges for a specific database
#
echo ""
echo "Lists all Table Privileges made to all users and roles"
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/alltabp
#
#     Display or PRINT/DELETE the report file
#
echo ""
ls -al alltabp.lis
#lp -c alltabp.lis
#rm alltabp.lis