What is the difference between login and a user?
Answer Posted / nidhi shah
A SQL Server login allows a user to connect to a server. A
login is the base concept.
Database user is associated with a login to allow specific
permissions on that database.
DB user without SQL Server login: not possible to create, a
Database User MUST be
related to a SQL Server login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between clustered and non-clustered indexes in ms sql server?
What is the template in sql?
How does clustered and non clustered index work?
Define constraints and give an example of their use?
What is normalization of database? What are its benefits?
How to select true false based on column value in sql server?
What are the different normalization forms?
What is a view and what are its advantages?
What is sql server profiler trace data file?
How do you create a data source?
Where are sql server user names and passwords stored in sql server?
What is isolation levels?
can a database be shrunk with users active? : Sql server administration
What the different topologies in which replication can be configured?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?