set_user_acl procedure

Related topics

Contained in package wwsec_api.

Call this procedure to grant a privilege on a specified object to a specified user.

procedure set_user_acl

(

p_person_id in number,

p_object_type_name in varchar2,

p_owner in varchar2 default wwctx_api.get_product_schema,

p_name in varchar2,

p_privilege in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_person_id

The unique ID of a user.

Note: To obtain this ID, call wwsec_api.id (p_user_name).

Datatype: in number

p_object_type_name

The name of the type of object referenced.

Note: These names are object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name.

Datatype: in varchar2

p_owner

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

Datatype: in varchar2
Default: wwctx_api.get_product_schema

p_name

The name of the specific object.

Datatype: in varchar2

p_privilege

The name of the privilege to be granted.

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

Datatype: in varchar2

Exceptions:

If p_person_id does not exist, a USER_NOT_FOUND_EXCEPTION is raised.

If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

Example:

wwsec_api.set_user_acl

(

p_person_id => 3,

p_object_type_name => wwsec_api.PAGE_OBJ,

p_owner => 'PORTAL',

p_name => '0/156',

p_privilege => wwsec_api.MANAGE_PRIV

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_person_id	The unique ID of a user. Note: To obtain this ID, call wwsec_api.id (p_user_name). Datatype: in number
p_object_type_name	The name of the type of object referenced. Note: These names are object_type_name constants. For example, ADMIN_OBJ, ITEM_OBJ, or another object type name. Datatype: in varchar2
p_owner	The name of the schema that owns the Access Control List entry, or another name space discriminator. Datatype: in varchar2 Default: wwctx_api.get_product_schema
p_name	The name of the specific object. Datatype: in varchar2
p_privilege	The name of the privilege to be granted. Note: These names are specified with privilege name constants of the wwsec_api package. Datatype: in varchar2
Exceptions: If p_person_id does not exist, a USER_NOT_FOUND_EXCEPTION is raised. If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised. Example: wwsec_api.set_user_acl ( p_person_id => 3, p_object_type_name => wwsec_api.PAGE_OBJ, p_owner => 'PORTAL', p_name => '0/156', p_privilege => wwsec_api.MANAGE_PRIV );

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