4.12 Creating a Workspace and Adding Oracle Application Express Users

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

4.12.1 About Workspaces and Users

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

You access the Oracle Application Express 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 Oracle Application Express Administration Services or have users submit requests. Oracle Application Express Administration Services is a separate application for managing an entire Oracle Application Express instance.

See Also:

4.12.2 Accessing Administration Services Using Oracle REST Data Services

Sign in to Oracle Application Express 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 Application Express instance called Oracle Application Express Administration Services.

To access Oracle Application Express Administration Services:

  1. In a Web browser, navigate to the Oracle Application Express Administration Services application.

    Tip:

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

    Because your setup uses Oracle REST Data Services go to:

    http://hostname:port/apex/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 Oracle REST Data Services Installation, Configuration, and Development Guide.

    apex is the service name defined when configuring Oracle REST Data Services.

  2. On the Sign In page:
    • Username - Enter the Oracle Application Express administrator account username you specified in Creating or Updating Your Instance Administration Account.

    • Password - Enter the Oracle Application Express administrator account password.

    • Click Sign In to Administration.

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

4.12.3 Creating a Workspace Manually

Sign in to Oracle Application Express Administration Services to create workspace manually.

To manually create a workspace you sign in to a separate application called Oracle Application Express Administration Services. You sign in to Oracle Application Express Administration Services using the ADMIN account and password created or reset during the installation process.

To create an Oracle Application Express workspace manually:

  1. Access Oracle Application Express Administration Services.

    Oracle Application Express 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.

4.12.4 Creating Oracle Application Express Users

Sign into Oracle Application Express Administration Services using an administrator password. From Manage Workspaces , click Manage Developers and Users , and click Create User. Enter the appropriate information.

To create an Oracle Application Express user account:

  1. Access Oracle Application Express Administration Services.

    Oracle Application Express Administration Services appears.

  2. Click the Manage Workspaces icon.
  3. Click Manage Developers and Users.
  4. Click Create User.
  5. Under User Attributes, enter the appropriate information. Fields marked with an asterisk are required.

    Tip:

    To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark.

  6. Under Account Privileges:
    1. Workspace - Select a workspace from the list.

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

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

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

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

    5. App Builder Access - Determines whether a developer has access to the App 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 log in failures allowed, specified in Workspace Preferences, then their account will be locked automatically.

  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.

  8. Click Create User or Create and Create Another.

4.12.5 Signing into a Workspace Using Oracle REST Data Services

Learn how to sign in to a workspace using the Oracle REST Data Services.

Use your credentials (that is, your workspace name, user name and password) to sign in to the workspace.

To sign in to your workspace:

  1. In a Web browser, navigate to the Oracle Application Express Sign In page.

    Because your setup uses Oracle REST Data Services, go to:

    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 Oracle REST Data Services Installation, Configuration, and Development 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: