Multiuser Environments

A multiuser environment is one in which other users can connect and make changes to the same database that you are working with. As a result, several users might be working with the same database objects at the same time. Thus, a multiuser environment introduces the possibility of your database diagrams being affected by changes made by other users, and vice versa. Such changes could include changes to copies of your diagrams, other users' diagrams that share database objects with your diagrams, or the underlying database.

A key issue when working with databases in a multiuser environment is access permissions. The permissions you have for the database determine the extent of the work you can do with the database. For example, to make changes to objects in a database, you must have the appropriate write permissions for the database. For more information about permissions in your database, see Managing Permissions.

As one of multiple users, you may need to address any of the following issues when working with the Database Designer:

• Ownership of Database Objects
  
• Diagrams Affected by Another User's Changes
  
  
• Database Objects Deleted by Another User