What is the difference between login and a user?
Answer Posted / sky
A login without a DB User will not have access to the
database or will access to only databases that have built
in Guest users created (by default, guest users are present
in Master & MSDB DB). DB User without a SQL Server login is
not possible. Each DB User must be related to a SQL Login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is repeatable read?
How to delete existing rows in a table?
what stored procedure would you use to view lock information? : Sql server administration
Which are the third-party tools used in sql server and why would you use them?
Explain what are the different index configurations a table can have?
What is difference between rownum and row_number?
what is a join and explain different types of joins? : Sql server database administration
What is the command to change the recovery model?
what is hash nonclustered index
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How do indexes help, types?
If the job running very slow what is the action you do
What is optimistic concurrency?
What is the most common type of join?
How to get all stored procedures in sql server?