BEGIN
apex_util.create_user (
p_user_name=> :NEW.USER_NAME,
p_first_name=> :NEW.FIRST_NAME,
p_last_name=> :NEW.LAST_NAME,
p_description=> :NEW.DESCRIPTION,
p_email_address =>:NEW.EMAIL_ADDRESS,
p_web_password=>:NEW.TEMP_PASSWORD,--p_group_ids=>set_group_id,
/*--For extra security, this resets the user's access to the APEX_BI schema only---*/
p_allow_access_to_schemas => 'STARS_DEMO',
/*--For extra security, this resets the user's default schema to APEX_BI--*/
p_default_schema => 'STARS_DEMO',
/*--For extra security, this resets the user's developer role to an end user Note: In FETCH USER and EDIT USER p_developer_privs is named p_developer_role ---*/
p_developer_privs => null,
p_account_locked => 'N',
p_failed_access_attempts =>0,
p_change_password_on_first_use=>'Y',
p_first_password_use_occurred =>'N');
/*--Email text defined --*/
End ;
No comments:
Post a Comment