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 the one-to-one relationship while designing tables.
Do you know what are acid properties of transaction?
Why people hate cursor?
What are the default system databases in sql server 2000?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Explain how to integrate the ssrs reports in application?
Describe triggers features and limitations?
Explain an automatic checkpoint
What is the purpose of forms?
What functions can a view be used to performed?
How do you make a trace?
Explain what is scheduled job and how to create it?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
how many triggers you can have on a table? : Sql server database administration