Which keyword is used with GRANT to specify future privileges on database or schema objects?

• A. ON NEXT
• B. ON COMING
• C. ON FORTHCOMING
• D. ON FUTURE

Answer: (D)

Future grants are about setting permissions for objects that don’t exist yet. In Snowflake you use the keyword FUTURE in the GRANT statement to define privileges that will automatically apply to any new objects of a given type within a database or schema. For example, granting a privilege on future tables in a schema means that any table created later will inherit that privilege for the specified role, without needing to grant again after creation. This is the exact mechanism the question is asking about.

So the correct form is to use FUTURE, as in GRANT SELECT ON FUTURE TABLES IN SCHEMA db.schema TO ROLE role; The other terms aren’t part of Snowflake’s syntax for future grants, so they won’t work in this context.