0 Replies Latest reply on Sep 7, 2003 7:58 PM by equine

    cmp specify database schema name

    equine

      hi,
      What are the configuration/settings in jboss so that jboss database user can access objects(table/index) from other schema. The database is oracle.

      Ex.
      jboss database user is user1. All the objects are in user2 schema. The user1 can access all the objects in user2 schema using user2.<object_name>

      I do not prefer to create public synonyms or views.

      Appreciated your response.

      Thanks,