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


Please Help Members By Posting Answers For Below Questions

How to install sql server 2005 express edition?

677


What is transaction server explicit transaction?

644


What is a primary index?

620


How to execute function in stored procedure sql server?

648


How to reaname table name without using sp_Rename in sql server..?

624






What is the rdl file?

96


How to connect ms access to sql servers through odbc?

633


What are the advantages of sql stored procedure?

637


What is indexing and its types?

628


What are the extra roles available in msdb? : sql server security

740


What is store procedure?

752


What are the different types of stored procedures?

661


Determine when an index is appropriate?

665


What is coalesce and check constraint in sql server?

615


Explain transaction server isolation?

652