Difference between login and user on sql server

CREATE USER [anc] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[anc]
GO

what is the difference between user and login.

I don’t understand how we create such users?

+3
source share
2 answers

Logins are server (level objects). Their correct name is "server principles" (see sys.server_principals). To access the servers, server privileges are granted, such as create databaseor permissions view server state.

Users are database objects that are correctly called "database principals" (see sys.database_principals). They are the recipients of database permissions, such as create tableor select.

1--1 SID, , sysadmin dbo.

- Service Broker (. ) . , , , , . .

+10

- SQL Server - .

( ).

+5

Source: https://habr.com/ru/post/1757486/


All Articles