|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
SQL Workshop includes a variety to object reports to help you better manage the objects in your database.
Topics:
Use the reports on the All Objects page to view all objects for the selected schema. Available reports include All Objects, Invalid Objects, Object Calendar, and Objects Counts by Type.
To access the reports available on the All Objects page:
Click the SQL Workshop icon on the Workspace home page.
The SQL Workshop home page appears.
Click Utilities, Object Reports, and then All Objects.
Select one of the following reports:
All Objects. Sort objects by creation date as well as last DDL (data definition language). To filter the report, select a object type, specify an object name, and click Go.
Invalid Objects. View all invalid objects in the database by object type. To filter the report, enter an object name, select a object type, and click Go.
Object Calendar. View all objects in a calendar format based on the date each database object was created.
Object Counts by Type. View counts of database object types for the selected schema.
Make a selection from the Schema list (optional).
To filter the report, select a object type, specify an object name, and click Go.
Each Oracle database has a data dictionary. An Oracle data dictionary is a set of tables and views that are used as a read-only reference about the database. For example, a data dictionary stores information about both the logical and physical structure of the database. A data dictionary also stores information about valid Oracle database users, integrity constraints for tables in the database, and the amount of space allocated for a schema object as well as how much of it is being used.
To browse the data dictionary:
Click the SQL Workshop icon on the Workspace home page.
The SQL Workshop home page appears.
Click Utilities, Object Reports, and then Data Dictionary.
The Data Dictionary appears, listing all the Oracle Data Dictionary views
To filter the report, enter a query in the Search field and click Go.
You can query for details about database objects in the Data Dictionary Browser.
Click the View icon to display Data Dictionary Browser. Use this form to query the Oracle Data Dictionary for details about database objects.
In the Data Dictionary Browser, select the appropriate views and click Query.
|
See Also: Oracle Database Concepts for information about the data dictionary |
PL/SQL reports enable you to view program unit arguments or unit line counts or search PL/SQL source code.
Topics:
Use the Program Unit Arguments report to view package input and output parameters.
To view the PL/SQL Arguments report:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Object Reports.
Click PL/SQL and then Program Unit Arguments.
To filter the report, enter a query in Object Name and click Go.
Use the Unit Line Counts report to view then number of lines of code for each object. Use this report to identify larger PL/SQL program units.
To view the Unit Line Counts report:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Object Reports.
Click PL/SQL and then Unit Line Counts.
To filter the report, enter an object name and click Go.
Use the Search PL/SQL Source code page to search the text within your PL/SQL code. Use this report to find references to tables or functions you might be thinking of deleting. You can also use this page to locate code when you can only recall a code snippet.
To search for PL/SQL source code:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Object Reports.
Click PL/SQL and then Search PL/SQL Source.
To filter the report:
In Object Name, enter a query.
In Text, enter the PL/SQL code you want to search for.
Click Go.
Security reports enable you to see privileges granted on database objects owned by other schemas. You can also use these reports to view database roles and system privileges. The SQL injection report is only available with Oracle Database 10g release 1 (10.2) or later.
Topics:
Role Privileges report shows the database roles that have been granted to a selected schema. Roles are collections of various privileges.
To view Role Privileges:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Object Reports.
Click Security and then Role Privileges.
The Role Privileges report appears.
The Object Grants report identifies privileges granted from or to the selected database schema. Use this report to determine the privileges for an existing schema has as well understand what privileges have been granted from the selected schema to other schemas.
To view the Object Grants report:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities, Object Reports, and Security.
Click User Privileges and then Object Grants.
The Object Grants report appears.
From Schema, select the database schema owner.
To filter the report, make a selection from the Show list and click Go.
The Column Privileges report identifies column privileges granted from or to the selected database schema. Use this report to determine the privileges for an existing schema as well as understand what privileges have been granted from the selected schema to other schemas.
To view the Column Privileges report:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities, Object Reports, and Security.
Click User Privileges and then Column Privileges.
The Column Privileges report appears.
From Schema, select the database schema owner.
To filter the report, make a selection from the Show list and click Go.
A SQL infection is a potential security vulnerability for any database-driven application. In a SQL Injection attack, the attacker modifies the parameters of an application in order to change the SQL statements passed to the database. For example, a SQL Injection attack could pass the text of a SQL statement or clause instead of user data from the application UI. A successful SQL injection attack may corrupt the database or grant access to privileged data.
|
Note: The SQL injection report is only available with Oracle Database 10g release 1 (10.2) or later. |
You can use the following two reports to check for vulnerabilities within a given schema:
Compile PL/SQL - This report analyzes and reports how user values concatenated into the text of dynamic SQL statements are transformed and passed through the whole application.
Review Vulnerabilities - Displays a report of potential vulnerable code.
To run the Compile PL/SQL Injection report:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities, Object Reports, and then Security.
Click SQL Injection and then Compile PL/SQL.
Select a schema from the Schema list on the right side of the page.
Only objects in the current schema display. Remember that the values available in the schema depend upon your workspace privileges.
To search for an object, enter a case insensitive query in the Object field and click Go.
Select the program units to be compiled and click Compile.
To remove program units, select the program units to be removed and click Remove Checked.
To view the Review Vulnerabilities report:
Run the Compile PL/SQL Injection report as described in the previous procedure.
Click the Review Vulnerabilities icon.
The Potential Vulnerable Code report appears, displaying packages, procedures, and links to potential program units with vulnerabilities.
To search for a package or process, enter a case insensitive query in the Search field and click Go.
To view details about a specific program unit, select the appropriate link.
To access the SQL Injection Tree View, click the Tree icon.
You can view specific details about the tables within your database by accessing the reports available on the Tables page.
To view the reports available on the Tables page:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities.
Click Object Reports and then Tables.
The Tables page appears.
Select a report as report to review.
To filter each report, enter search criteria in the fields provided and click Go.