Start with….

[code language=”sql”]
select :WORKSPACE_ID from dual;
[/code]

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.

[code language=”sql”]

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;
/
[/code]

Create page items