课程: Programming Foundations: Databases
今天就学习课程吧!
今天就开通帐号,24,600 门业界名师课程任您挑!
Access control, compliance, and injection
- We haven't talked about security for our simple database. But this is an important aspect of databases, especially when they contain personally identifiable information or other sensitive data. Most database management systems provide various access control mechanisms, including user accounts and control over whether certain people can access certain tables or even individual columns. In the database we can grant user varying levels of access to hold databases, tables, and even specific actions. We might define the user who can create, read, update, and delete data but who is not allowed to change the schema of the database. And we might create another user who only has read access and who can't modify data stored in the database at all. When you're designing a database and granting access to the database and the data it's important to consider your business requirements. It's also very important to consider any compliance…