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
When to use null data driven subscription?
Explain sql server service broker?
What is the difference between join and inner join?
What is the parse query button used for?
What is use of except clause? How it differs from not in clause?
What is table-valued sub query?
How to convert a unicode strings to non-unicode strings?
What is the default sql server instance name?
What is the sql profiler?
What do we have to check in database testing?
Which rendering formats are affected by the pagesize properties?
Explain difference between cross join and full outer join?
What is the difference between a primary key and a unique key? Are they the same?
Define right outer join in sql server joins?
Write an SQL query to obtain the 2nd highest salary.