Previous Next JavaScript must be enabled to correctly display this content

## 6.11 Creating a Workspace and Adding APEX Users

Before you can develop or install applications, you must create a workspace, add Oracle APEX users, and sign in to your workspace.

- About Workspaces and Users
  A workspace enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private.
- Signing In To Administration Services
  Sign in to Oracle APEX Administration Services using the Instance administrator account and password created or reset during the installation process.
- Creating a Workspace Manually
  Sign in to Oracle APEX Administration Services to create workspace manually.
- Creating APEX Users
  Create new users in Oracle APEX Administration Services.
- Signing In to Your Workspace
  Sign in to a workspace by navigating to the Oracle APEX Sign In page.

Parent topic: Installing and Configuring Oracle REST Data Services and Oracle APEX

### 6.11.1 About Workspaces and Users

A workspace enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private.

You access the APEX home page by logging in to a workspace using a JavaScript enabled Web browser.

Each workspace has a unique ID and name. An instance administrator can create a workspace manually within APEX Administration Services or have users submit requests. APEX Administration Services is a separate application for managing an entire APEX instance.

Parent topic: Creating a Workspace and Adding APEX Users

### 6.11.2 Signing In To Administration Services

Sign in to Oracle APEX Administration Services using the Instance administrator account and password created or reset during the installation process.

To manually create a workspace and user accounts, you sign in to a separate application for managing an entire Oracle APEX instance called Oracle APEX Administration Services.

To sign in to Oracle APEX Administration Services:

1. In a Web browser, navigate to the Administration Services Sign In page:

   Tip:

   By default, the context root for accessing Oracle APEX through Oracle REST Data Services is `/ords`. If you wish to have a context root of `/apex` for accessing Oracle APEX, rename the `ords.war` file to `apex.war` before installing Oracle REST Data Services. See Deploying and Monitoring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.

   By default, Administration Services installs to the following location:

       http://hostname:port/ords/apex_admin

   Where:

   - `hostname` is the name of the system where Oracle REST Data Services is installed.

   - `port` is the port number assigned when configuring Oracle REST Data Services. In a default installation, this number is 8080. To learn more, see Installing and Configuring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.

   - `ords` is the service name defined when configuring Oracle REST Data Services.

2. On the Sign In page:
   1. Username - Enter the Instance administrator account username specified in Creating or Updating Your Instance Administration Account.
   2. Password - Enter your Instance administrator account password.
   3. Click Sign In to Administration.

      Oracle APEX Administration Services appears.

   Note that, depending on your setup, you might be required to change your password when you log in for the first time.

See Also:

Oracle APEX Administration Services in Oracle APEX Administration Guide

Parent topic: Creating a Workspace and Adding APEX Users

### 6.11.3 Creating a Workspace Manually

Sign in to Oracle APEX Administration Services to create workspace manually.

To manually create a workspace you sign in, sign in to APEX Administration Services using the `ADMIN` account and password created or reset during the installation process.

To create an APEX workspace manually:

1. Access APEX Administration Services.

   Administration Services appears. Next, create a workspace.

2. Click Manage Workspaces.
3. Under Workspace Actions, click Create Workspace.

   The Create Workspace Wizard appears.

4. For Identify Workspace, enter the following:
   1. Workspace Name - Enter a unique workspace name.
   2. Workspace ID - Leave Workspace ID blank to have the new Workspace ID automatically generated. A Workspace ID must be a positive integer greater than 100000.
   3. Workspace Description - Enter a workspace description.
   4. Click Next.
5. For Identify Schema, specify whether you are re-using an existing schema or creating a new one.

   If you are using an existing schema:

   1. For Re-use existing schema, select Yes.
   2. Select a schema from the list.
   3. Click Next.

   If you are creating a new schema:

   1. For Re-use existing schema, select No.
   2. Enter a schema name and password.
   3. Specify a space quota.
   4. Click Next.
6. For Identify Administrator, enter the Workspace administrator information and click Next.
7. Confirm your selections and click Create Workspace.

See Also:

- Creating Workspaces in Administration Services in Oracle APEX Administration Guide
- Managing Existing Workspaces in Oracle APEX Administration Guide

Parent topic: Creating a Workspace and Adding APEX Users

### 6.11.4 Creating APEX Users

Create new users in Oracle APEX Administration Services.

Create new users by signing into the APEX Administration Services application using your Instance administrator password.

To create an APEX user account:

1. Sign in to APEX Administration Services.
2. Click Manage Workspaces.
3. Under Workspace Actions, click Manage Developers and Users.
   The Manage Developers and Users page appears.
4. Click Create User.
5. Under User Attributes, enter the appropriate information. Fields marked with an asterisk are required.

   Tip:

   Most attributes in APEX include field-level Help. Attributes with field-level Help, have light gray icon that resembles a question mark (?). To view field-level Help, click the Help icon.

   1. Username - Enter the username used to sign 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. Default Date Format - Specify the default Oracle date format for the user. This option controls the default date format within SQL Workshop.
6. Under Account Privileges:

   1. Workspace - Select a workspace from the list.

   2. Default Schema - Specify the default schema used for this user.

      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.

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

   4. User is an 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.

   5. User is a developer - Specify if this user should have developer privileges.

      Developers must have access to either App Builder, SQL Workshop, or Data Reporter. These components may not be available if they are switched off by the Instance Administrator.

   6. App Builder Access - Determines whether a developer has access to the App Builder.

      An Administrator will always have access to the App Builder.This attribute is always disabled when App Builder Access is disabled for the workspace by an Administrator.

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

      An Administrator will always have access to SQL Workshop.This attribute is always disabled when SQL Workshop Access is disabled for the workspace by an Administrator.

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

      An Administrator will always have access to Team Development.This attribute is always disabled when Team Development Access is disabled for the workspace by an Administrator.

   9. Data Reporter Builder Access - Determines whether a user has access to Data Reporter.

      An Administrator will always have access to Data Reporter.This attribute is always disabled when Data Reporter Access is disabled for the workspace by an Administrator.

   10. Data Reporter Role - Displays the role for Data Reporter.Instance user management allows defining a data reporter administrator only. Use Data Reporter Manage Users to define other data reporter role for this user.

   11. 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 log in failures allowed, specified in Workspace Preferences, then their account will be locked automatically.

7. Under Password:

   - Password - Enter the password . Only enter a password if you are creating a new account with a password or you are updating the password for an existing account.

   - Confirm Password - Enter the password again.

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

8. Click Create User or Create and Create Another.

See Also:

Managing Users Across an Oracle APEX Instance in Oracle APEX Administration Guide

Parent topic: Creating a Workspace and Adding APEX Users

### 6.11.5 Signing In to Your Workspace

Sign in to a workspace by navigating to the Oracle APEX Sign In page.

After you create a workspace and APEX users, you can sign in to your workspace using your credentials (that is, your workspace name, user name and password).

To sign in to a workspace:

1. In a Web browser, navigate to the APEX Sign In page:

       http://hostname:port/apex/

   Where:

   - `hostname` is the name of the system where Oracle REST Data Services is installed.
   - `port` is the port number assigned when configuring Oracle REST Data Services. In a default installation, this number is 8080. To learn more, see Installing and Configuring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.
   - `apex` is the service name defined when configuring Oracle REST Data Services.

   The Sign In page appears.

2. On the Sign In page, enter:
   - Workspace - Enter the name of your workspace.
   - Username - Enter your user name.
   - Password - Enter your case-sensitive password.
3. Click Sign In.

   Note that, depending on your setup, you might be required to change your password when you log in for the first time.

See Also:

- Creating Workspaces in Administration Services in Oracle APEX Administration Guide
- Managing Requests in Oracle APEX Administration Guide

Parent topic: Creating a Workspace and Adding APEX Users