What access control policy will be put into place when future grants are assigned to both database and schema objects?

Question

Options

• ADatabase privileges will take precedence over schema privileges.
• BSchema privileges will take precedence over database privileges.
• CAn access policy combining both the database object and the schema object will be used, with
• DAn access policy combining both the database object and the schema object will be used, with

• A
  4% (1)
• B
  83% (20)
• C
  8% (2)
• D
  4% (1)

Explanation

When future grants are defined on the same object type for a database and a schema in the same database, the schema-level grants take precedence over the database level grants, and the database level grants are ignored. This behavior applies to privileges on future objects granted to one role or different roles. Future grants allow defining an initial set of privileges to grant on new (i.e. future) objects of a certain type in a database or a schema. As soon as the new objects are created inside the database or schema, the predefined set of privileges are assigned to the object automatically without any manual intervention.

No community discussion yet for this question.