What is the difference between login and a user?
Answer Posted / sky
A login without a DB User will not have access to the
database or will access to only databases that have built
in Guest users created (by default, guest users are present
in Master & MSDB DB). DB User without a SQL Server login is
not possible. Each DB User must be related to a SQL Login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to select all columns of all rows from a table with a select statement in ms sql server?
What is a result set object returned by odbc_exec()?
how to do partition in sqlserver
Can we use where and having clause together?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is a trace frag?
How many databases Microsoft SQL server provides?
What is the difference between composite index and covering index?
What is ssl in sql server?
What were the latest updates to SQL Azure service?
What is cursors? And what are the different types of cursor?
Explain contrast amongst grouped and non-bunched records?
Can you explain different types of joins?
What is b tree index?
What is the purpose of linked server configuration in sql server?