Which of the following is true about database permissions?
A)connecting to a database does not require permissions as long as the user is logged on to the server
B)permissions can only be granted to the database as a whole
C)permissions can be granted on a schema
D)tables are securables that group together a collection of objects

Question

Quizplus · Accepted Answer

Permissions can be granted on a schema, which is a logical container for database objects such as tables, views, and stored procedures. This allows for more granular control over who can access and modify specific parts of the database. Options A and B are incorrect, as connecting to a database does require appropriate permissions, and permissions can be granted at various levels including individual objects. Option D is incorrect as tables are not securables, but rather a type of object that can have permissions applied to it.

Which of the Following Is True About Database Permissions