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
Define Joins?
Tell me something about security and sql azure?
How to use subqueries in the from clause in ms sql server?
How to get the definition of a view out of the sql server?
Can we write trigger for view?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Why use identity in sql server?
What does executeupdate return?
What is function of master database?
What is difference between index seek vs. Index scan?
Can group by be used without aggregate functions?
What is cdc in sql server?
How many types of keys are there?
How to concatenate two binary strings together?
What are points to remember while using the fillfactor argument?