User Creation API

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

User Creation API

Post by admin »

DECLARE

l_workspace_id := apex_util.find_security_group_id (p_workspace => 'ERPSTUFF');
apex_util.set_security_group_id (p_security_group_id => l_workspace_id);

BEGIN

APEX_UTIL.CREATE_USER(
p_user_name => 'SIKANDAR',
p_first_name => 'Malik Sikandar',
p_last_name => 'Hayat',
p_description => 'This script is a sample',
p_email_address => 'info@erpstuff.com',
p_web_password => 'Pakistan',
p_developer_privs => 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
p_default_schema => 'WKSP_ERPSTUFF',
p_allow_access_to_schemas => 'WKSP_ERPSTUFF',
p_change_password_on_first_use => 'N',
p_attribute_01 => '123 456 7890');

END;
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest