MS SQL Server 2012 Training - Implementing Security - SQL Server 2012 Part 3/3
https://sqlserver2014tutorial.com/
This three-part MS SQL Server 2012 video series covers security features of SQL Server 2012 along with demos on how to implement these features.
Part 1 – This video covers MS SQL Server 2012 Security terminology and usage.
Part 2 – This video covers MS SQL Server 2012 server login creation using both SQL Server Management System (SSMS) and Transact SQL (TQSL)
Part 3 – This video covers the security features of MS SQL Server 2012
This third part video discusses Roles in SQL Server, which is a collection of principals made for easy administration and management.
Two types of Roles:
SERVER ROLE: These SQL Server roles are security principals that group other principals. Server-level roles are server-wide in their permissions scope. Several Server Role types are listed and discussed in the video.
DATABASE ROLE: These SQL Server roles are database-wide in their permissions scope. There are two types of database-level roles: fixed-database roles that are predefined in the database and user-defined database roles that you can create. Several Database Role types for MS SQL Server 2012 are listed and discussed in the video.
Important Transact SQL commands related to Principal management:
CATALOG VIEWS: Commands can be used to list the server principals, database principals and the database members.
USER / PERMISSION: Using commands in TSQL, you can create a new login, user, role and scheme as well as assign permissions.
Please subscribe to our channel and like our videos! We have many training videos on MS SQL 2012
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/