What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 22520 Views
- HCL, I also Faced
- E-Mail Answers
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 options which must be set to allow the usage of optimistic models?
What is acid db?
How to use transact-sql statements to access the database engine?
How to concatenate two strings in SQL Server.
What are horizontal and vertical scaling?
Are semicolons required at the end of sql statements in sql server 2005?
What is nonclustered index on computed columns?
How to find tables without indexes?
What is a result set object returned by odbc_exec()?
Explain what is log shipping?
when would you go for denormalization? : Sql server database administration
What is 2nf normalization?
What is database mirroring?
What are the two modes of authentication in sql server?
Give an example of why you would want to denormalize a database
