What is the difference between login and a user?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the microsoft sql server delete command?
What is database white box testing?
Does an index slow down updates on indexed columns?
Define inner join in sql server joins?
Explain indexing and what are the advantages of it?
Write the SQL query to drop, truncate and delete table.
What are trace flags and mention a few common trace flags used with sql server?
optimization techinques
Would you store your query in a ssrs report or a database server? State the reason why?
What is the default sql server instance name?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is efficiency data?
What is logon trigger?
what are cursors? : Sql server database administration
List out the different types of locks available in sql server?