Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Team-Fly    
 
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.

Team-Fly    
Top
 

Related

Категории