What is the difference between login and a user?
Answer Posted / infodba
Login is a server principle and User is a database principle
Each server principle can be a guest user as a public role for each database can view any database.
But a contained user of a database cannot access other databases and cannot be a guest login for the server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the limitations in ssrs on sql server express edition?
Can sql servers linked to other servers?
How to change the password of a login name in ms sql server?
How to drop an existing table?
What is rtm version in sql server?
List the various tools available for performance tuning?
What are the acid properties?
Explain different types of self contained sub query?
How to create median function?
Can you edit the .rdl code associated with a linked report?
What are types of scd? : sql server analysis services, ssas
What are magic tables in sql server?
What are the approximate numeric data types?
Do you know what is rank function?
in the physical file layout, where should the transaction log be stored in relation to the data file?