What is the difference between windows authentication and
sql server authentication
Answer Posted / visala
windows authentication has a concept of ACL(access control
list). Means in a group we can give permissions/restriction
to a perticular person in a group individually.
Is sql authentication there no concept of ACL. Means we
can't give permissions/restrictions individually. we can
give permissoins to the hole group .
in windows we can give permissions before enetering into
the server.
in sql we can give permissions after entering into the
server only.
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What are the different editions available in sql server 2000?
What is correlated subquery in sql server?
What is the distinction amongst delete and truncate?
What is Transparent Data Encryption?
What is the maximum size of column in sql server?
Explain full-text indexing?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is primary key, unique key, and foreign key?
Can you import Microsoft Excel data to SSRS?
Write SQL queries on Self Join and Inner Join.
What is the bookmark lookup and rid lookup?
Explain various data region available in ssrs with their use?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is difference between line feed ( ) and carriage return ( )?
How do you size a resultset?