Oracle9 i Developer: PL/SQL Programming. Chapter 7. Program Unit Dependencies. Objectives. Identify local program unit dependencies Determine direct and indirect dependencies View data dictionary information concerning dependencies Run the dependency tree utility
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Allows a user to create, modify, and drop program units within their own schema.
CREATE ANY PROCEDURE
Allows a user to create program units in any schema. Does not allow the modification or dropping of the program units.
ALTER ANY PROCEDURE
Allows a user to modify program units in any schema.
DROP ANY PROCEDURE
Allows a user to drop program units in any schema.
EXECUTE ON program_unit_name
Allows a user to execute a specific program unit.
EXECUTE ANY PROCEDURE
Allows a user to execute program units in any schema.Program Unit Privileges
Shows all privileges of the current schema, direct and indirect
Shows all roles granted to the current schema
Shows only direct privileges of the current schema
Shows only direct roles granted to the current schemaPrivileges - Data Dictionary