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 single-user mode and what are the steps you should follow to start sql server in single-user mode?
How do I view views in sql server?
Is port 1433 secure?
How to create stored procedures with parameters in ms sql server?
What is difference between clustered and non clustered index?
Explain the disadvantages of cursors?
Does any body please help me what question's have asked for SSRS in the interview?
your distribution database is full what will u do
What are scalar functions?
Define ACID properties in a Database?
Explain the xml support sql server extends?
What is the use of sql profiler in sql server 2012?
What is the difference between mysql and mysqli?
explain declarative management framework (dmf) in sql server 2008?
What new data source types were added in ssrs 2014?