How Does a Database Become Secure?

Up to this point you haven't worried much about the security of the databases you have created. Has it occurred to you that you might not want other users to come in and tamper with the database information you have so carefully entered? What would your reaction be if you logged on to the server one morning and discovered that the database you had slaved over had been dropped (remember how silent the DROP DATABASE command is)? We examine in some detail how two popular database management systems (Personal Oracle and MySQL) enable you to set up a secure database. You will be able to apply most of this information to other DBMSs, so make sure you read this information even if Oracle or MySQL are not your systems ...

Get Sams Teach Yourself SQL in 21 Days, Fourth 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.