Difference between a User and a Login in SQL Server

by

A “Login” grants the principal entry into the SERVER.

A “User” grants a login entry into a single DATABASE.

One “Login” can be associated with many users (one per database).

Each of the above objects can have permissions granted to it at its own level. See the following articles for an explanation of each

More Related Contents:

  1. Insert an image in a column of a table that already has 5 columns
  2. Get top 1 row of each group
  3. Referring to a Column Alias in a WHERE Clause
  4. Convert Month Number to Month Name Function in SQL
  5. How to avoid the “divide by zero” error in SQL?
  6. SET versus SELECT when assigning variables?
  7. Generate a resultset of incrementing dates in TSQL
  8. Real life example, when to use OUTER / CROSS APPLY in SQL
  9. Getting result of dynamic SQL into a variable for sql-server
  10. How to get difference between two rows for a column field?
  11. Better techniques for trimming leading zeros in SQL Server?
  12. SQL statement to select all rows from previous day
  13. Concatenate values based on ID
  14. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  15. Splitting delimited values in a SQL column into multiple rows
  16. Insert Picture into SQL Server 2005 Image Field using only SQL
  17. Execute Stored Procedure from a Function
  18. varbinary to string on SQL Server
  19. SQL : in clause in stored procedure:how to pass values
  20. SQL GROUP BY CASE statement with aggregate function
  21. separate comma separated values and store in table in sql server
  22. Best way to do nested case statement logic in SQL Server
  23. Restrict an SQL Server connection to a specific IP address
  24. SQL Server 2005 ROW_NUMBER() without ORDER BY
  25. Can an INNER JOIN offer better performance than EXISTS
  26. Cumulative Total in MS Sql server [duplicate]
  27. SQL query to group by day
  28. Export table data from one SQL Server to another
  29. SQL can I have a “conditionally unique” constraint on a table?
  30. SQL, How to Concatenate results?

Leave a Comment