During this hour, you learn about one of the most fundamental purposes 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 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
Note
The SQL standard refers to a database user identification as an Authorization Identifier (authID). In most major implementations, authIDs are referred to simply as users. This book refers to Authorization Identifiers as users, database users, usernames, or database user accounts. The SQL standard states that the Authorization Identifier is a name by which the system knows the database user.