what are procobj_grants
Date: Mon, 31 Oct 2011 08:36:19 +0100
With datapump Oracle makes a difference between object grants and procobject grants. In the schema_level_exports view, procobj_grant is stated to be "schema procedural grants in the selected schema"
SQL> select object_path, comments from schema_export_objects where object_path in ('OBJECT_GRANT', 'PROCOBJ_GRANT');
Object grants on the selected tables
Schema procedural object grants in the selected schemas
Does anyone know what exactly falls under PROCOBJ_GRANT? I have found that grants on jobs, schedules, programs, ... are procobj grantss, but grants on procedures are not, but I don't know if there are any other grants that fall under procobj_grant.
Oracle Database Administrator
tel +32(0)3 451 23 82