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

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

Which sql server table is used to hold the stored procedure script?

0 Answers  

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

What information is maintained within the msdb database?

0 Answers  




What is plan freezing?

0 Answers  

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

What is the use of MOVE keyword in restore command

3 Answers   IBM,

What are the advantages of partitioning?

0 Answers  

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

What are the types of database recovery models?

0 Answers   HCL,

What is user-defined scalar function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories