What is the difference between login and a user?
Answer Posted / 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 |
Post New Answer View All Answers
Does a full backup include transaction log?
How to generate random numbers with the rand() function in ms sql server?
What is the standby server?
how you can deploy an ssrs report?
Tell me what is de-normalization and what are some of the examples of it?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to count rows with the count(*) function in ms sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Differentiate between SQL and ORACLE joins and write their syntax.
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are three major types of constraints?
What are the different types of join?
Write a SQL query to make a column as unique?
Explain triggers in sql?
What is awe?