Which of the following is true about database access control?
A)to access a database the SQL Server login must be mapped to a database user
B)members of the sysadmin server role don't have access to databases by default
C)once a user logs in to the SQL Server, they have automatic access to underlying database objects
D)the database user login name must be different from the server login name

Question

Quizplus · Accepted Answer

To access a database, the SQL Server login must be mapped to a database user. This is done to control access at the database level, and ensure that only authorized users have access to specific databases and their objects.

Which of the Following Is True About Database Access Control