Which of the following is true about database permissions?
A)access to databases is controlled by Windows logon authentication
B)database users are defined for each database
C)server-level permissions provide the least access to SQL databases
D)permissions can only be set at the server or database level

Question

Quizplus · Accepted Answer

Database users are defined for each database, and their permissions are set at the database level. Windows logon authentication and server-level permissions may also play a role in granting access, but the specific permissions for each user are set at the database level. Option C is incorrect because server-level permissions can grant significant access to SQL databases, including the ability to create or modify databases and tables. Option D is incorrect because permissions can also be set at the object level, such as for individual tables or stored procedures within a database.

Which of the Following Is True About Database Permissions