?
Solved

Oracle Application Express workspace credentials

Posted on 2012-04-10
2
Medium Priority
?
1,089 Views
Last Modified: 2012-04-11
Dear All

i am unable to login to Application Express workspace but i could login to SYS user using toad.

How can i reset the workspace password . i ran a script which can change Internal Admin user credentials, but how to do it for my workspace.

workspace name :TRAINING
username: QUALITY

Thanks
0
Comment
Question by:Guidestar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
gatorvip earned 600 total points
ID: 37827784
Can you log into the INTERNAL workspace with the admin user? If so, you can do the following:
- From the Home screen, click on Find A User (on the right hand side, under Workspace Tasks)
- Edit the user QUALITY, then change the password
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 600 total points
ID: 37827835
in your apex install directory you should see a script

apxchpwd.sql  -- is this the one you ran?

which, when run as SYS, will allow you to update the INTERNAL admin password,  from there you can update any/all workspace passwords as needed
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question