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.