Server roles , Database roles & Application roles in SQL Server || Ms SQL

Server-Level Roles : Describes fixed server roles and the permissions associated with them in SQL Server.SQL Server provides server-level roles to help you manage the permissions on a server.
Database-Level Roles : Describes fixed database roles and the permissions associated with them.
To easily manage the permissions in your databases, SQL Server provides several roles which are security principals that group other principals.
aka.ms/sql-permissions-poster
Application roles : docs.microsoft.com/en-us/sql/...
For more information n server roles: docs.microsoft.com/en-us/sql/...
Permissions: docs.microsoft.com/en-us/sql/...

[@SaphireTech]

Read loads of documentation but never really got a sense of what it actually looks like and how it's setup. Actually seeing it really helps, thanks!

[@ShivajiSaduvelly]

Simply clear explanation with examples. thank you very much !!!

[@Harshita_Bhardwaj]

Your channel is very very helpful! Thank you for the great explanation🙏

[@amitbhardwaj8801]

Thank for sharing the knowledge

[@moinshakira2558]

「明確なメッセージ、明確な構造、理解しやすい、ありがとう」、

[@sureshpal5613]

great video

[@xyz-wz3ok]

Very helpful..

[@jingtingong6177]

Hi, why we need schema for the database user?

[@banalasiva5743]

through command how to give permissions to server level and database level

[@waldemarsoto9091]

Hello, a question, does the user 'sa' have all the permissions and privileges to use the databasemail?

[@user-ex7tz8df8l]

Yes

[@chattoronkaadda4342]

Hi sir, can you tell me sql 2012 server sa default password???

[@aahaa8049]

Can u share me link to create login and user sql

[@righttolearnbk]

To create login
1) Windows Authentication:
CREATE LOGIN [Domain_name\Login_name] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
2) SQL authentication:
CREATE LOGIN [Login_name] WITH PASSWORD=N'p@ssw0rd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
To create user in a database:
USE [DB_name]
GO
CREATE USER [user_name] FOR LOGIN [Login_name]
GO