LESSON 17Database Security

In this lesson, we discuss database security. We specifically look at various SQL statements and constructs that enable you to administer and effectively manage a relational database. Like many other topics you have studied thus far, how a database management system (DBMS) implements security varies widely among products. We focus on the popular database products, Oracle and MySQL, to introduce this topic. By the end of the lesson, you will be able to do the following:

• Create users

• Change passwords

• Create roles

• Use views for security purposes

• Use synonyms in place of views

Security’s Role in Database Administration

Security is an often overlooked aspect of database design. Most computer professionals enter ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.