Creating Multiple Users at Once

Workspace administrators can create multiple user accounts in a single operation.

To create multiple user accounts at once:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

   The Administration page appears.

3. Click Manage Users and Groups.

4. On the Tasks list, click Create Multiple Users.

   The Create Multiple Users page appears.

5. In List of Email Addresses, enter or copy and paste email addresses separated by commas, semicolons, or new lines.

6. Under Users:

   • List of Email Addresses - Enter or copy and paste email addresses separated by commas, semicolons, or new lines.

   • Usernames - Specify whether to include or exclude the domain name. Select one of the following:

     • Set username to full email address

     • Exclude @ domain as part of the username

       Removes all text after the @ symbol (for example, user1@xyz.com becomes user1).

7. Under Account Privileges:

   • Default Schemas - Specify the default schema used for data browsing, application creation, and SQL script execution. When using workspaces that have more than one schema available, this schema is the default for creating applications, performing SQL queries, and so on.

   • Accessible Schemas (null for all) - Enter a colon-delimited list of schemas for which this developer has permissions when using the SQL Workshop. The list of schemas you enter here restricts the user to a subset of the full set of schemas provisioned for the workspace and determines what schema names the user sees in SQL Workshop.

   • Users are workspace administrators - Specify if these users should have workspace administrator privileges.

     Administrators are given access to all components. Additionally, they can manage user accounts, groups, and development services. Components may not be available if they are switched off by Instance Administrators Additionally, they can also manage user accounts, groups, and development services.

   • Users are Developers - Specify if these users should have developer privileges. Developers must have access to either Application Builder, SQL Workshop, or both. Components may not be available if they are switched off by Instance Administrators.

   • Application Builder Access - Determines whether a developer has access to the Application Builder.

   • SQL Workshop Access - Determines whether a developer has access to the SQL Workshop.

   • Team Development Access - Determines whether a developer has access to the Team Development.

8. Under Password:

   • Password - Specify a password. Passwords are case sensitive. Developers can change their own passwords. Developers with Administrator privilege can change the passwords of users within the same workspace.

   • Confirm Password - Enter the password again.

9. Click Apply Changes.