Add or Remove Roles

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Add or Remove Roles

Post by admin »

apex_acl.add_user_role
( p_application_id => wwv_flow_security.g_flow_id,
, p_user_name => p_app_user
, p_role_static_id => 'ACCOUNTANT'
);

apex_acl.remove_user_role
( p_application_id => default wwv_flow_security.g_flow_id,
, p_user_name => p_app_user
, p_role_static_id => 'ACCOUNTANT'
);

APEX_ACL.REMOVE_ALL_USER_ROLES (
p_application_id in number wwv_flow_security.g_flow_id,
p_user_name in varchar2 );

APEX_ACL.REPLACE_USER_ROLES (
p_application_id IN NUMBER DEFAULT apex_application.g_flow_id,
p_user_name IN VARCHAR2,
p_role_ids IN apex_t_number );
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests