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

• 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.
• Accessing Administration Services Using Embedded PL/SQL Gateway
  You can sign in to Oracle Application Express Administration Services using the ADMIN account and password created or reset during the installation process.
• Creating a Workspace Manually
  Sign in to Oracle Application Express Administration Services to create workspace manually.
• 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.
• Signing into a Workspace Using the Embedded PL/SQL Gateway
  Learn how to sign in to a workspace using the embedded PL/SQL gateway.

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

• "Browser Requirements"

• "Creating Workspaces" in Oracle Application Express Administration Guide

• "Managing Workspace and Change Requests" in Oracle Application Express Administration Guide"

A.11.2 Accessing Administration Services Using Embedded PL/SQL Gateway

You can sign in to Oracle Application Express Administration Services using the ADMIN 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. 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 embedded PL/SQL gateway, go to:

   http://hostname:port/apex/apex_admin
   

   Where:

   hostname is the name of the system where Oracle XML DB Protocol server is installed.

   port is the port number assigned to HTTP on the Oracle XML DB Protocol server. In a default installation, this number is 8080. If you are using the Oracle Database 12c or later multitenant architecture, then each pluggable database (PDB) will have a distinct port number.

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

2. On the Sign In page:

   • Username - Enter admin.

   • Password - is the database access descriptor (DAD) defined in the configuration file.

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

See Also:

• "Creating or Updating Your Instance Administration Account"

• "Oracle Application Express Administration Services" in Oracle Application Express Administration Guide.

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

See Also:

• "Accessing Administration Services Using Oracle REST Data Services"

• "Oracle Application Express Administration Services" in Oracle Application Express Administration Guide

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

See Also:

"Accessing Administration Services Using Oracle REST Data Services"

A.11.5 Signing into a Workspace Using the Embedded PL/SQL Gateway

Learn how to sign in to a workspace using the embedded PL/SQL gateway.

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 Embedded PL/SQL Gateway, go to:

   http://hostname:port/apex/
   

   Where:

   • hostname is the name of the system where Oracle XML DB Protocol server is installed.

   • port is the port number assigned to HTTP on the Oracle XML DB Protocol server. In a default installation, this number is 8080. If you are using the Oracle Database 12c or later multitenant architecture, then each pluggable database (PDB) will have a distinct port number.

   • apex is the database access descriptor (DAD) defined in the 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:

• "Creating Workspaces" in Oracle Application Express Administration Guide

• "Managing Workspace and Change Requestsin Oracle Application Express Administration Guide"