Creating New User Accounts

Workspace administrators can create three different types of user accounts:

• Developers can create and edit applications and view developer activity, session state, workspace activity, application, and schema reports. In Icons view, developers are yellow.

• Workspace administrators perform administrator tasks specific to a workspace, such as managing user accounts, managing groups, altering passwords of users within the same workspace, and managing development services. In Icons view, Workspace administrators are red.

• End users have no development privileges and can access only applications that do not use an external authentication scheme. In Icons view, End users are green.

To create a new user account:

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. Click Create User.

   The Create User page appears.

5. Under User Identification, enter:

   1. Username - Enter the username used to log in to the system. Restrictions include:

      • Maximum length of 100 characters

      • No spaces

      • Only these special characters are permitted: ampersand (@) and period (.)

   2. Email Address - Enter the valid email address for this user.

   3. First Name - Enter the first or given name to further identify the user (optional).

   4. Last Name - Enter the last or family name to further identify the user (optional).

   5. Description - Enter comments about this user (optional).

6. Under Account Privileges:

   1. 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. This setting does not control security, only the user's preference.

   2. Accessible Schemas (null for all) - Leave this blank to enable the end user to access all schemas in the workspace, or enter a colon-delimited list of schemas for which this user has permissions when using the SQL Workshop.

   3. User is a workspace administrator - Specify if this user 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.

   4. User is a developer - Specify if this user 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.

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

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

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

   8. Set Account Availability - Select Locked to prevent the account from being used. Select Unlocked to allow the account to be used.

      If the user has exceeded the maximum login failures allowed, specified in Workspace Preferences, then there account will be locked automatically.

   
   

   Tip: An Instance administrator can configure these settings for an entire Oracle Application Express instance and define password complexity policies. See "Enabling Login Controls for All Workspaces". "About Password Policies", and "Configuring Password Policies"

   
   

7. Under Password:

   • Password - Enter a case sensitive password.

   • Confirm Password - Enter the password again.

   • Require Change of Password On First Use - Select No to allow the user to use the same password until it expires. Select Yes to require the user to change the password immediately when logging in the first time.

   
   

   Tip: An Instance administrator can configure these settings for an entire Oracle Application Express instance and define password complexity policies. See "Enabling Login Controls for All Workspaces". "About Password Policies", and "Configuring Password Policies"

   
   

8. Under User Groups, optionally select one or more user groups by holding down the CTRL key and selecting the groups.

9. Click Create User or Create and Create Another.

   
   

   See Also: "Using Groups to Manage Application Express Users" and "Adding and Removing Users from a Group"