 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle Security
Internals Scripts
--
*********************************************
rem*******************************************************************
rem NAME: db_tgnts.sql
rem
rem FUNCTION: Produce report of table or procedure grants showing
rem GRANTOR, GRANTEE or ROLE and specific GRANTS.
rem
rem INPUTS: Owner name
rem
********************************************************************
rem
COLUMN grantee FORMAT A18 HEADING "Grantee|or Role"
COLUMN owner FORMAT A18 HEADING "Owner"
COLUMN table_name FORMAT A30 HEADING "Table|or Proc"
COLUMN grantor FORMAT A18 HEADING "Grantor"
COLUMN privilege FORMAT A10 HEADING "Privilege"
COLUMN grantable FORMAT A19 HEADING "Grant|Option?"
rem
BREAK ON owner SKIP 4 ON table_name SKIP 1 ON grantee ON grantor ON
REPORT
rem
SET LINESIZE 130 PAGES 56 VERIFY OFF FEEDBACK OFF
The above is from the bestselling book
Mike Ault’s Oracle Internals Monitoring & Tuning Scripts.
It's only $49.95and you can download all the scripts immediately:
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
| 
