Creating New User Accounts

Workspace administrators can create three different types of user accounts:

• Developers can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports.

• 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.

• End users have no development privileges and can access only applications that do not use an external authentication scheme.

To create a new user account:

1. Navigate to the Workspace home page.

2. From the Administration list, click Manage Application Express Users.

   The Manage Application Express Users page appears.

3. Click Create.

   The Create User page appears.

4. Under User Identification, enter the appropriate information.

5. Under Developer Privileges:

   • Accessible Schemas (null for all) - Enter a colon-delimited list of schemas for which this developer has permissions when using the SQL Workshop. This list of schemas 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.

   • Default Schema - Identifies the default schema used for data browsing, application creation, and SQL script execution.

   • User is a developer - To add this user as a developer or workspace administrator, select Yes. For end users, select No.

     Developers can create and modify applications and database objects as well as view developer activity, session state, workspace activity, application, and schema reports.

   • User is a workspace administrator - To add this user as a workspace administrator, select Yes. For developers or end users, select No.

     In addition to having developer privileges, workspace administrators can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services.

     
     

     Note: You create end users by adding them as users but not defining them as either developers or workspace administrators, restricting their privileges.

     
     

6. Under Account Control:

   • Set Account Availability - Select Unlocked to allow a user to log in to this account. Select Locked to prevent a user from logging in to this account. Select Unlocked to enable the account to be used.

   • Require Change of Password on First Use - Select Yes to require the user to change the password immediately after logging in with the current, temporary password.

     This rule applies to the use of this account for developers and workspace administrators. It also applies to all users who use this account when logging in to developed applications.

   
   

   Tip: An Oracle Application Express administrator can configure these settings for an entire Oracle Application Express instance. See "Enabling Login Controls for All Workspaces".

   
   

7. Under User Groups, select an optional user group.

   You can use groups to restrict access to various parts of an application. Groups are primarily useful when using Application Express Authentication.

8. Under Additional Attributes, update the user's name or add descriptive information about the user or account.

9. Click Create User or Create and Create Another.

   
   

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