6.11 Creating a Workspace and Adding Oracle Application Express Users

Learn about creating 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.

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

6.11.2 Accessing Administration Services Using Oracle HTTP Server

Learn how to access Oracle Application Express administration services.

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. You sign in to Oracle Application Express Administration Services using the ADMIN account and password created or reset during the installation process.

To access Oracle Application Express Administration Services:

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

    Because your setup uses Oracle HTTP Server with mod_plsql go to:

    http://hostname:port/pls/apex/apex_admin
    

    Where:

    hostnameis the name of the system where Oracle HTTP Server is installed.

    port is the port number assigned to HTTP on the Oracle HTTP Server. In a default installation, this number is 7777.

    plsis the indicator to use the mod_plsql cartridge.

    apexis the database access descriptor (DAD) defined in the mod_plsql configuration file.

  2. On the Sign In page:
    • Username - Enter admin.

    • Password - Enter the Oracle Application Express administrator account password you specified in your instance administration account.

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

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

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

6.11.4 Signing into a Workspace Using the Oracle HTTP Server

Learn how to sign in to a workspace using the Oracle HTTP Server.

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 HTTP Server (Apache) and mod_plsql, go to:

    http://hostname:port/pls/apex
    

    Where:

    • hostname is the name of the system where Oracle HTTP Server is installed.

    • port is the port number assigned to HTTP on the Oracle HTTP Server. In a default installation, this number is 7777. You can find information about your Oracle HTTP Server installation's port number from either of the following files:

      ORACLE_BASE\ORACLE_HOME\install\portlist.ini
      ORACLE_BASE\ORACLE_HTTPSERVER_HOME\Apache\Apache\conf\httpd.conf
      

      Be aware that if you change a port number, it is not updated in the portlist.ini file. You can only rely on this file immediately after installation.

    • pls is the indicator to use the mod_plsql cartridge.

    • apex is the database access descriptor (DAD) defined in the mod_plsql configuration file.

    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: