Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between login and a user?
- 13 Answers
- 30970 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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 |
Explain different isolation levels?
How make remote connection in database?
Why we use functions in sql server?
Explain the properties of subqueries in sql server?
Diff. b/w Full Outer Join And Cross Join?
What do you mean by stored techniques? How would we use it?
How to find the last update record in SQL Server?
How to create a user to access a database in ms sql server using "create user" statements?
Which command using Query Analyzer will give you the version of SQL server and operating system?
what is the signification difference of this bit data type between sql 6.5 and later version sql server?
How is a full-text index updated?
What are the fixed server level roles? : sql server security
-
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)
