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 use inner join in sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
what is the main function of a query parameter?
What are the parts of a function?
Explain filtered indexes benefits?
What is difference between unique and primary key?
Do you know what are pages and extents? : SQL Server Architecture
Benefits of Stored Procedures?
What do you understand by mirroring?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is serializable?
How to drop an existing stored procedure in ms sql server?
What is simple indexing method?
Explain what is the difference between a local and a global temporary table?
What are commit and rollback in sql?