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
Explain how many normalization forms?
Define indexes?
what is the system function to get current user's user id? : Sql server database administration
What are the diifferences between the ms sql server vs mysql?
What is primary key index?
Tell me what do we need queues in sql service broker?
What are the differences between DDL, DML and DCL in SQL?
Explain what are partitioned views and distributed partitioned views?
What is an execution plan?
Do you know how to store and query spatial data?
How to access the deleted record of an event?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the difference between NOROW and LOCKROW?
What is mean by dml?
What is the sql server 2000 version number?