Hi folks
I was trying to change the current_scheme of user A (App_User) to user B (Schema_Owner) through Oracle Express Web Interface but failed.
I was following Tim Hall's advice: http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php#current_schema_approach
Logon as Appl_User through:
- Oracle Express Interface, current_schema = "Appl_User"
- Oracle Express SQL Command, current_schema = "Schema_Owner"
- Oracle SQL Developer, current_schema = "Schema_Owner"