?What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Question

What will be an ideal response?

Answer 1

It's important to ensure that data is as accurate as possible. Many database users do not have much experience with database applications and could inadvertently corrupt data. However, database users need to be able to add, change, and delete data. If they make updates using forms and special queries, such as action queries, users can manipulate only the data on forms and queries, without accessing the rest of the data in the tables upon which the forms and queries are built. To minimize the risk of users inadvertently corrupting data, users should be restricted to updating only the data they need. For this reason, a database administrator might create forms and special queries for the purpose of restricting the users' ability to access only authorized data. Users also need to review and print information from a database using reports, forms, and queries. Similarly, users should not be allowed to change the design of any database object or the design of the user interface. You can create a user interface that meets all these needs and restrictions. When users open a database, you can present them with a form that allows them to choose among the available forms, reports, and queries and to navigate from one object to another object as they perform their work. At the same time, you can limit users to this controlled user interface and prevent them from circumventing it, thereby preventing them from changing any aspect of the design of the database. By considering the needs of the users and by using the features and tools provided by the DBMS, you can ensure users can work productively with a database and ensure the integrity of the data stored in the database.?