It has been long since I worked in Oracle Express. In starting to work on it again, I find I can't get into anything. Does one's login credentials expire? The only thing that still works is my system password. My diary, in which I have recorded everything(usernames and passwords) is not helping me. The three workspaces' credential seem to be wrong(either the usernames or passwords). Even the Administrator username or password seem to be wrong or not working. I therefor cannot go their to reset them. I can only log into Oracle Express with my system username and password. That is as far as I can go. Can someone help me out here. .
you could connect to your database as SYS, and then get the Workspace ID for the workspace you need to access:
SELECT TO_CHAR(workspace_id), workspace FROM apex_workspaces;
And then execute following block:
BEGIN wwv_flow_api.set_security_group_id(123456); -- id obtained from previous query apex_util.create_user( p_user_name => 'USER' -- desired username ,p_web_password => 'PWD' -- desired password ,p_web_password_format => 'CLEAR_TEXT' ,p_developer_privs => 'ADMIN:BROWSE:CREATE:DATA_LOADER:DB_MONITOR:EDIT:HELP:MONITOR:SQL:USER_MANAGER' ,p_account_expiry => TRUNC(SYSDATE) + 365 ,p_change_password_on_first_use => 'N'); COMMIT; END;
Now you can access the workspace with a new user who is admin, so you have full control.