tags:

views:

4

answers:

0

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:

  1. Oracle Express Interface, current_schema = "Appl_User"
  2. Oracle Express SQL Command, current_schema = "Schema_Owner"
  3. Oracle SQL Developer, current_schema = "Schema_Owner"