get_public_objects function

Related topics

Contained in package wwsec_api.

Call this function to return a list of objects granted to PUBLIC.

The function returns a list of objects of the specified type and owner (and optionally of the specified privilege), that are granted to
PUBLIC (i.e., to group 0 ).

function get_public_objects

(

p_object_type_name in varchar2,

p_privilege in varchar2 default null,

p_owner in varchar2 default wwctx_api.get_product_schema

)

return array;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_object_type_name

The name of the type of object referenced.

Note:These names can be specified with object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name.

Datatype: varchar2

p_privilege

The name of a privilege you may want to check for the existence of on the specified object.

Note: These names are specified with privilege name constants of the wwsec_api package.

Note: If you pass in a null value, this function returns all public user privileges granted for the specified object type and owner.

Datatype: varchar2
Default: null

p_owner

The name of the schema that owns the Access Control List entry, or another name space discriminator.

Datatype: varchar2
Default: wwctx_api.get_product_schema

Returns:

This function returns an array of object names (of a specified type), within a site that are accessible by PUBLIC users.

Exceptions:

This function raises no exceptions.

Example:

l_list_of_objects wwsec_api.array;
l_list_of_objects := wwsec_api.get_public_objects
(
p_object_type_name => wwsec_api.WORKFLOW_OBJ,
p_privilege => wwsec_api.VIEW_PRIV,
p_owner => wwctx_api.get_product_schema
);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_object_type_name	The name of the type of object referenced. Note:These names can be specified with object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name. Datatype: varchar2
p_privilege	The name of a privilege you may want to check for the existence of on the specified object. Note: These names are specified with privilege name constants of the wwsec_api package. Note: If you pass in a null value, this function returns all public user privileges granted for the specified object type and owner. Datatype: varchar2 Default: null
p_owner	The name of the schema that owns the Access Control List entry, or another name space discriminator. Datatype: varchar2 Default: wwctx_api.get_product_schema
Returns: This function returns an array of object names (of a specified type), within a site that are accessible by PUBLIC users. Exceptions: This function raises no exceptions. Example: l_list_of_objects wwsec_api.array; l_list_of_objects := wwsec_api.get_public_objects ( p_object_type_name => wwsec_api.WORKFLOW_OBJ, p_privilege => wwsec_api.VIEW_PRIV, p_owner => wwctx_api.get_product_schema );

Related topics
Security API package	PDK PL/SQL API Reference - Home