-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|