Hour 19. Managing Database Security

What You’ll Learn in This Hour:

Database security

Security versus user management

Database system privileges

Database object privileges

Granting privileges to users

Revoking privileges from users

Security features in the database

In this hour, you learn the basics of implementing and managing security within a relational database using SQL and SQL-related commands. Each major implementation differs on syntax with its security commands, but the overall security for the relational database follows the same basic guidelines discussed in the ANSI standard. You must check your particular implementation for syntax and any special guidelines for security.

What Is Database Security?

Database security ...

Get Sams Teach Yourself SQL in 24 Hours, 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.