Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Part VI. Using SQL to Manage Users and Security
Hour 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 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
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.
