What is the difference between login and a user?
Answer Posted / dharmendra k. dixit
Login is the way of authentication into MSSQLServer,
and Users are the members of that Authentication as per
their Access rights for a specific DataBase.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
How does recursive cte works in sql server?
Explain atomicity?
Why the trigger fires multiple times in single login?
Explain what is log shipping?
Why olap is used?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Can you explain what is indexed view? How to create it?
what data regions are and what are the different data regions?
How to list all user defined functions in the current database?
Explain various data region available in ssrs with their use?
What is sql server management studio? : sql server management studio
What are magic tables in sql server?
What are the new features are introduced in sql server 2012 reporting services?
How to create a local temporary stored procedure?
What are data files?