Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Create Workspace and add Apex users

Posted by Hendry chinnapparaj on July 1, 2010

Create a Workspace and Add Oracle Application Express Users

You access the Oracle Application Express home page by logging in to workspace using a Web browser. Your Web browser must support JavaScript and the HTML 4.0

and CSS 1.0 standards. See “Browser Requirements” on page 2-2.

A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and

applications private. 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 “Creating Workspaces” and “Managing Workspace Requests” in Oracle Application Express Administration Guide.

http://pcu026.shalom.com:8080/apex/apex_admin

userid: admin

password: ****

Click Manage Workspaces.

3. Under Manage Workspaces, click Create Workspace.

The Create Workspace Wizard appears.

4. For Identify Workspace, enter a workspace name and description and click Next. à ORACLEDBA

5. For Identify Schema, select the Oracle Forms application schema. à reuse schema:no;schema:oracledba; schema pwd:oracledba;space:100mb

Admin username: admin

Password: ***

First name: Hendry

Last name: Dasan

Email: hendry.oracle@shalom.com.au

Confirm request à create workspace

Workspace successfully provisioned.

Workspace ORACLEDBA provisioned with administrator ADMIN.

Database user ORACLEDBA created with default tablespace APEX_1284401228498898 using datafile /u02/oradata/apex4/APEX_1284401228498898.dbf

Creating Oracle Application Express Users

To create an Oracle Application Express user account:

1. Log in to Oracle Application Express Administration Services as described in the previous section. See “Logging in to Oracle Application Express Administration

Services” in Oracle Application Express Administration Guide.

Manage workspaces à manage developers and users à create user

User Attributes

Username
Email Address
First Name
Last Name
Description

Workspace à oracledba

Default schema à oracledba

User is an administrator à no

Account availability à unlocked

Create end user

——————–

Password: xx15908

Confirm password: xx15908

Require change of password:no

Create’

Create Developer user

Username:ndry

Email: Hendry.oracle@shalom.com.au

First name : Hendry

Last name: Dasan

Description: developer

Workspace: oracledba

Default schema: oracledba

User is administrator: no

User is developer: yes

Application builder access: yes

Sql workshop access: yes

Team development access: yes

Account availability: unlocked

Password: hendry

Confirm: hendry

Require change of password on first use: no

Login to your workspace as end user and test

http://cpu026.shalom.com:8080/apex/

Enter Application Express workspace and credentials.

Workspace
Username
Password xx15908

Login to your workspace as Developer  and test

http://cpu026.shalom.com:8080/apex/

Enter Application Express workspace and credentials.

Workspace
Username
Password hendry
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: