Managing Database Security

In the modern age of global network connectivity, news of data breaches, leaked information, and malicious exploitation should make clear the need to secure access to database content. However, database security doesn’t end at avoiding unauthorized access by nefarious outsiders. Restrictions on the content authorized users can create, view, modify, and use are equally important. Further, restricting user access to the structural design of a database can help stop careless or malicious alterations to the schema, interface, and script functions. Even minor accidental changes to a formula or script can be catastrophic to a company’s workflow and may result in severe financial consequences. Only those with adequate technical skills and competent knowledge of business logistics should be authorized to act as a developer. FileMaker’s credentialing features offer an array of choices for how to secure a file and limit who can do what. This chapter explores these features, covering the following topics: