However same set of users accounts should be allowed to access both applications.Are these database users or some sort of application/business users that are stored as data in the tables etc. Too often people talk about 'users' of applications but are not really talking of actual database users, so you need to be clear of the details when explaining.
Napster wrote:This is a design issue, and as such a matter of personal taste.
Any recommendations? And any issues that I could face if I choose to create a new schema.The main reason why people (i.e. developers) hate schemas is that they impose a management overhead: granting of privliges on objects and data, in both directions, and perhaps the development of additional code such as views or API packages with restricted interfaces. In my opninon these are bogus objections, born out of slackness, but it be disineguos to deny that multiple schemas do require extra typing.