Hour 18. Managing Database Users

What You’ll Learn in This Hour:

Types of users

User management

The user’s place in the database

The user versus the schema

User sessions

Altering a user’s attributes

User profiles

Dropping users from the database

Tools utilized by users

In this hour, you learn about one of the most critical administration functions for any relational database: managing database users. Managing users ensures that your database is available to the required people and application while keeping external entities out. Considering the amount of sensitive commercial and personal data that is stored in databases, this hour is definitely one that you should pay careful attention to.

User Management in the Database ...

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.