Creating New User Accounts

Workspace administrators can create three different types of user accounts:

Developers create and edit applications.
Workspace administrators perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files.
End users have no development privileges and are defined to provide access control to applications that do not use an external authentication scheme.

Creating a Developer

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

To create a new developer:

Navigate to the Workspace home page.
From the Administration list, click Manage Application Express Users.

The Manage Application Express Users page appears.
Click Create Developer.

The Create User page appears.
Under User Identification, enter the appropriate information. Required fields are marked with a red asterisk (*).
Under Developer Privileges, specify the following:
- Accessible Schemas - 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 - Select Yes.
  
  Developers can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports.
- User is a workspace administrator - Select No.
  
  Workspace administrators additionally can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services.
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.
Click Create User or Create and Create Another.

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

Creating a Workspace Administrator

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.

To create a new workspace administrator:

Navigate to the Workspace home page.
From the Administration list, click Manage Application Express Users.

The Manage Application Express Users page appears.
Click Create Workspace Administrator.

The Create User page appears.
Under User Identification, enter the appropriate information. Required fields are marked with a red asterisk (*).
Under Developer Privileges, specify the following:
- Accessible Schemas - 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 Scheme - Identifies the default schema used for data browsing, application creation, and SQL script execution.
- User is a developer - Select Yes.
  
  Developers can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports.
- User is a workspace administrator - Select Yes.
  
  Workspace administrators additionally can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services.
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.
Click Create User or Create and Create Another.

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

Creating an End User

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

To create a new end user:

Navigate to the Workspace home page.
From the Administration list, click Manage Application Express Users.

The Manage Application Express Users page appears.
Click Create End User.

The Create User page appears.
Under User Identification, enter the appropriate information. Required fields are marked with a red asterisk (*).
Under Developer Privileges, specify the following:
- Accessible Schemas - 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 - Select No.
- User is a workspace administrator - Select No.
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.
Click Create User or Create and Create Another.

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