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 is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to change the ownership of a schema in ms sql server?
What is difference between after and before?
What does man by sql wildcard characters in sql server?
How to create a trigger for insert only?
What is truncate table?
What is cdc in sql server?
What is postgresql server?
What are truncate options available in sql server? : sql server database administration
How to execute multiple stored procedures at one time in sql server?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Explain about Joins?
How to create percentile function?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How do I start sql server 2017?