 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle Security
Internals Scripts
ttitle "TABLE
GRANTS BY OWNER AND TABLE"
DEFINE OUTPUT = db_tgnts
SPOOL &output
REM
SELECT
owner,
table_name,
grantee,
grantor,
privilege,
grantable
FROM
dba_tab_privs
SEE CODE DEPOT FOR FULL SCRIPT
ORDER BY
owner,
table_name,
grantor,
grantee;
REM
SPOOL OFF
PAUSE Press enter to continue
Here is a sample listing.
Table Grantee Grant
Owner or
Proc or Role Grantor Privilege Option?
--------
-------- ----------- --------- -------------- ---
DSPTDBA
ACCCAR DSPT_DEV DSPTDBA DELETE NO
INSERT NO
SELECT NO
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. |
|
| 
