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 install sql server 2005 express edition?
What is transaction server explicit transaction?
What is a primary index?
How to execute function in stored procedure sql server?
How to reaname table name without using sp_Rename in sql server..?
What is the rdl file?
How to connect ms access to sql servers through odbc?
What are the advantages of sql stored procedure?
What is indexing and its types?
What are the extra roles available in msdb? : sql server security
What is store procedure?
What are the different types of stored procedures?
Determine when an index is appropriate?
What is coalesce and check constraint in sql server?
Explain transaction server isolation?