Documenting Oracle Databases Complete Oracle Database Schema by Mike Ault

By Mike Ault

Show description

By Mike Ault

Show description

Read or Download Documenting Oracle Databases Complete Oracle Database Schema Auditing PDF

Best organization and data processing books

JDBC Recipes: A Problem-Solution Approach

JDBC Recipes presents easy-to-implement, usable suggestions to difficulties in relational databases that use JDBC. it is possible for you to to combine those suggestions into your web-based functions, corresponding to Java servlets, JavaServer Pages, and Java server-side frameworks. this convenient e-book lets you reduce and paste the suggestions with none code adjustments.

The effects of sterilization methods on plastics and elastomers: the definitive user's guide and databook

This broadly up-to-date moment version used to be created for scientific machine, scientific packaging, and nutrition packaging layout engineers, fabric product technical aid, and research/development team of workers. This entire databook includes very important features and homes info at the results of sterilization tools on plastics and elastomers.

Additional info for Documenting Oracle Databases Complete Oracle Database Schema Auditing

Example text

Type in (2, 4, 5) /* table, view, synonym */ PAGE 56 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. objauth$ where grantee# in ( select kzsrorol from x$kzsro ) ) or exists (select null from v$enabledprivs where priv_number in (-45 /* LOCK ANY TABLE */, -47 /* SELECT ANY TABLE */, -48 /* INSERT ANY TABLE */, -49 /* UPDATE ANY TABLE */, -50 /* DELETE ANY TABLE */)) ) Try running the above documentation script against the DBA_ series of views, a DBA can learn a lot from looking at the way those views are constructed.

All of the DDL to define PLSQL stored objects such as packages, package bodies, procedures and functions is stored in the DAB_SOURCE PAGE 47 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. TLFeBOOK ROBO BOOKS MONOGRAPH DOCUMENTING YOUR DATABASE view and additional information on them stored in the DBA_OBJECTS view. By creating a script which joins these two tables we can re-create any of the objects mentioned above. The scripts shown below could more readily be done in PLSQL, but was deliberately done in SQL and SQLPLUS to show that it can be done.

Type in (2, 4, 5) /* table, view, synonym */ PAGE 56 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. objauth$ where grantee# in ( select kzsrorol from x$kzsro ) ) or exists (select null from v$enabledprivs where priv_number in (-45 /* LOCK ANY TABLE */, -47 /* SELECT ANY TABLE */, -48 /* INSERT ANY TABLE */, -49 /* UPDATE ANY TABLE */, -50 /* DELETE ANY TABLE */)) ) Try running the above documentation script against the DBA_ series of views, a DBA can learn a lot from looking at the way those views are constructed.

Download PDF sample

Rated 4.47 of 5 – based on 20 votes