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 is stored procedures?

0 Answers  

What is scheduled job and how to create it?

0 Answers  

Can you pass expressions to function parameters?

0 Answers  

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

What is openrowset sql server?

0 Answers  




How can change procedure in sql server?

0 Answers  

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

What is the correct order of the logical query processing phases?

0 Answers  

What stored procedure would you use to view lock information?

0 Answers  

Explain indexed view?

1 Answers  

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

Explain about nested stored procedure?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories