Server roles , Database roles & Application roles in SQL Server || Ms SQL
HTML-код
- Опубликовано: 22 авг 2024
- 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-per...
Application roles : docs.microsoft...
For more information n server roles: docs.microsoft...
Permissions: docs.microsoft...
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!
Simply clear explanation with examples. thank you very much !!!
Your channel is very very helpful! Thank you for the great explanation🙏
Thank for sharing the knowledge
「明確なメッセージ、明確な構造、理解しやすい、ありがとう」、
Very helpful..
great video
through command how to give permissions to server level and database level
Hi, why we need schema for the database user?
Hello, a question, does the user 'sa' have all the permissions and privileges to use the databasemail?
Yes
Can u share me link to create login and user sql
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
Hi sir, can you tell me sql 2012 server sa default password???