Start with....

select :WORKSPACE_ID from dual;

In the SQL Workshop's "SQL Command Processor" to determine your workspaces workspace_id (also known as a security_group_id internally).  Assuming that query came back with a value of 12345, you could then run a block like.


BEGIN
    wwv_flow_api.set_security_group_id(p_security_group_id=>12345);

    wwv_flow_fnd_user_api.create_fnd_user(
    p_user_name     => 'regular_user',
    p_email_address => 'myemail@mydomain.com',
    p_web_password  => 'regular1') ;

    wwv_flow_fnd_user_api.create_fnd_user(
    p_user_name       => 'developer_user',
    p_email_address   => 'myemail@mydo.com',
    p_web_password    => 'dev1',
    p_developer_privs => 'ADMIN') ;

end;
/

Create page items

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram