1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between login and a user?

Question Posted / mirjawad

Answers were Sorted based on User's Feedback



What is the difference between login and a user?..

Answer / prasad

Login is for Entire SQL server Instance,
User is for particular database.

1 login=many users.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between login and a user?..

Answer / infodba

Login is a server principle and User is a database principle

Each server principle can be a guest user as a public role for each database can view any database.

But a contained user of a database cannot access other databases and cannot be a guest login for the server.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between login and a user?..

Answer / revathi

used for protection login
user is a customer.just view cannot alter

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More SQL Server Interview Questions

Why should you use or avoid select * statements?

0 Answers  

What is the advantage of sql server?

0 Answers  

What happens if null values are involved in comparison operations?

0 Answers  

How to delete an existing database user?

0 Answers  

Explain Trigger with an example?

2 Answers  




How do I list the available tables in a database I'm querying?

4 Answers  

How we can compare two database data?

0 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

What is sql or structured query language?

0 Answers  

what purpose does the model database serve? : Sql server database administration

0 Answers  

Can you explain different types of locks in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories