What is the difference between login and a user?
Answers were Sorted based on User's Feedback
Answer / prasad
Login is for Entire SQL server Instance,
User is for particular database.
1 login=many users.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / revathi
used for protection login
user is a customer.just view cannot alter
| Is This Answer Correct ? | 4 Yes | 9 No |
What is indexing a document?
what is a transaction? : Sql server database administration
What is the library index called?
What is the sql server 2000 version number?
What stored by the msdb? : sql server database administration
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
What are the acid properties?
Does sql server use java?
System variable and temporary variables
What are the differences between union, intersect, and minus operators?
What is sql server transaction log file?
How sql server enhances scalability of the database system?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)