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 |
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What do you mean by stored techniques? How would we use it?
What does it mean to invest in the index?
What are alternate keys?
What is Replication?
what is difference between view and Dip.
Explain about analysis services?
What is the use of MOVE keyword in restore command
What are the elements of dbms?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What are the different sql server versions?
What does the not null constraint do?
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)