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 table join?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Explain where clause?
How retrieve field names from the table in SQL through JAVA code?
What are database states in ms sql server?
How can we get count of the number of records in a table?
How to use group functions in the select clause in ms sql server?
What do you mean by cardinality?
What are partitioned views?
What is stored procedures?
How do I edit a procedure in sql server?
Explain the difference between control flow and data flow?
Oracle (3259)
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)