What is the difference between login and a user?
Answer Posted / potula
login defines access privillege to sql server. A user
defines the accessible objects and rights the login has
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference RDBMS and Graph Database?
What is mapping schema?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are “phantom rows”?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Do you know what are pages and extents? : SQL Server Architecture
What command must you use to include the not null constraint after a table has already been created?
what are the new features in SSRS?
What is the recovery model? List the types of recovery model available in sql server?
How can you stop stored procedures from recompiling?
Why are you getting errors when creating a new odbc dsn?
What are the reporting services components?
What is the purpose of update statistics and scope_identity() function?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration