Chapter 18. Managing Database Users
During this hour, you learn about one of the most critical administration functions for any relational database: managing database users. You will learn the concepts behind creating users in SQL, user security, the user versus the schema, user profiles, user attributes, and tools that users utilize.
The highlights of this hour include:
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
By the Way
The SQL standard refers to a database user identification as an Authorization Identifier (authID
). In most major implementations, authID
s are referred to simply as users. This ...
Get Sams Teach Yourself SQL in 24 Hours, 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.