2.13. Privileges
The majority of scripts you develop will fall into one of two categories:
Scripts to execute a specific function, such as loading test data into a table.
Reporting scripts (e.g., a report on how much space your tables and indexes are using).
Report scripts tend to bring in to question your database privileges, particularly with regard to querying the data dictionary. There are three general categories of data dictionary views—these categories are designated with the prefixes: “USER,” “ALL,” and “DBA”—these categories are fully described in Chapter 5. In addition to these views, you also have the Oracle “real-time” performance views. The performance views contain dynamic information that is essentially “real-time” data on the current ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
