6 Replies Latest reply: Jan 7, 2013 1:58 AM by Maahjoor RSS

    Applications Centralization

      Dear all,

      i am using oracle developer 10g with oracle database 10g r2.

      i have 10 different applications like HR,INVENTORY,PRODUCTION and so on.
      each application has its own login screen and a schema.
      each schema has a table USERS for authenticating users and a table USER_ACCESS to control which user could access which form or report.

      now my management want to centralize these applications, means a single login screen and centralized access control. a single page for all the applications from
      which a user could select a form or a report for example.

      what things should i keep in mind before proceeding?
      what is the methodology?

      if i am not clear, kindly suggest me.