SQL Server Managing Logins and DB Users

SQL Server Managing Logins and DB Users. This presentation covers the following topics:

  • Principals
  • Securables
  • SQL Logins
  • Windows-Authenticated SQL Server Logins
  • SQL Server–Authenticated Logins
  • Creating Users
  • Fixed Server-Level Roles
  • Altering Existing Logins
  • Login-Related Catalog Views
  • Removing Logins
  • Server Roles
  • User-Defined Server Roles
  • Credentials
  • Database Users
  • Database Roles
  • Application Roles
  • Data Encryption –Keys

For more presentations regarding this subject, use this link.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…