Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between login and a user?
- 13 Answers
- 31525 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / visala
login is server level and user is database level.
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / dharmendra k. dixit
Login is the way of authentication into MSSQLServer,
and Users are the members of that Authentication as per
their Access rights for a specific DataBase.
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / peter jacob
A login defines access privillege to the SQL Server. A user
defines the accessible objects and rights the login has.
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / sivakumar
Login is authentication into server level
And Users is authentication into object level.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / hameed
Login means authentication to server (access to MSSQLSERVER)
where as User means Login is authenticated with rights and
permissions to access the database objects (roles assigned
to Login)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / potula
login defines access privillege to sql server. A user
defines the accessible objects and rights the login has
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sky
A login without a DB User will not have access to the
database or will access to only databases that have built
in Guest users created (by default, guest users are present
in Master & MSDB DB). DB User without a SQL Server login is
not possible. Each DB User must be related to a SQL Login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nidhi shah
A SQL Server login allows a user to connect to a server. A
login is the base concept.
Database user is associated with a login to allow specific
permissions on that database.
DB user without SQL Server login: not possible to create, a
Database User MUST be
related to a SQL Server login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
What are data resources?
What is auditing in sql server?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What is etl - extraction, transformation, and loading?
What are the indexes in sql server?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Benefits of Stored Procedures?
Explain system functions or built-in functions? What are different types of system functions?
How to fetch the next row from a cursor with a "fetch" statement?
-
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)
