Hi,

My question is easy... I've one DB which contains 150 tables.

Unfortunatelly, this 150 tables are are dispatching between 10 differents applications (customer, bill, vendor, contact, user ...) and only 5-6 tables are common for applications

A user owned all objects of DB & so, all applications use this user for connection.

Is it better to create one user by application which will own grants and synonyms on objects it use... or keep one user which is used by all applications.

What is advantage/disadvantage for maintenance, security, users, performances ...

Thanx.