What is the difference between login and a user?

Answer Posted / sivakumar

Login is authentication into server level
And Users is authentication into object level.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does normalization work?

507


Can I work with several databases simultaneously? : sql server management studio

567


List out a number of the wants to setup a SQL Server failover cluster?

585


What is the difference between char, varchar and nvarchar?

581


What is spid in sql server profiler?

542






Explain about extended stored procedure?

494


What are the two authentication modes in sql server?

607


In what sequence sql statement is processed?

590


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

509


What is database architecture? : SQL Server Architecture

555


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

591


How to list all field names in the result set using mssql_field_name()?

528


What are parameterized reports? What are cascading parameters in ssrs reports?

100


What is the data type of time?

522


Explain the truncate command?

524