In Application Express, there is no standard way of copying users in an existing workspace to a new workspace. Everytime you create a new workspace, all developers and users must be added manually.
Here’s a little script that does the work for you. Just replace the WORKSPACE with the name of your own workspace where you want to copy the users from, and execute in a SQL Command window in a new workspace. Might save you some time!
declare cursor c_usr is select t.user_name, t.first_name, t.last_name, t.email_address , t.default_schema , fd.developer_role from APEX_040100.WWV_FLOW_FND_USER t join apex_040100.wwv_flow_developers fd on fd.user_id = t.user_id where t.security_group_id = ( select cp.PROVISIONING_COMPANY_ID from apex_040100.wwv_flow_companies cp where cp.short_name = 'WORKSPACE') ; begin for r_usr in c_usr loop APEX_UTIL.CREATE_USER( p_user_name => r_usr.user_name , p_first_name => r_usr.first_name, p_last_name => r_usr.last_name, p_description => null, p_email_address => r_usr.email_address, p_web_password => 'Welkom01', p_developer_privs => r_usr.developer_role, p_default_schema => r_usr.default_schema, p_allow_access_to_schemas => null, p_change_password_on_first_use => 'Y' ); end loop; end;
When you quickly want to create an ISO image from a CD or DVD disk, simply do the following:
- insert the disk in your optical drive (yeah, I know this is obvious!)
- open the Disk Utility (Schijfhulpprogramma in Dutch)
- Go to Folder in the menu (Archief in Dutch)
- Then select New > Image from “<diskname>” (Nieuwe > Schijfkopie van “<schijfnaam>” in Dutch)
- Choose the options “Dvd/cd-master” with encoding “None” (Schijfkopiestructuur and Codering in Dutch). Save it to your Desktop (default location), and give a name, for instance DiskImage
- The Disk Utility will create a DiskImage.cdr at your desktop. Grab a coffee, there’s plenty of time.
- Now we will convert it to an image, with some help from the command prompt.
- Open a terminal window. Type Command+Space, then type Terminal, and press enter.
- In the terminal window, type the following commands:
cd ~/Desktop hdiutil makehybrid -iso -ov DiskImage.iso DiskImage.cdr
This will take a few minutes, again. When it is finished, you may close the terminal.
If you foresee that you will need this disk in a Windows environment, you might want to consider making a joliet hybrid.
To do this, change the command above to the following:
cd ~/Desktop hdiutil makehybrid -iso -joliet -ov DiskImage.iso DiskImage.cdr
You’re done! Now you have created an iso image of your disk. You can write it to a recordable at a later time, or open it directly bij doubleclicking the file. This works in both OS X and Ubuntu Linux. Windows has no built-in solution for opening .ISO files.