Which combination of privileges is required, at a minimum, to create additional streams on a Snowflake table?

• A. Database USAGE only.
• B. Schema CREATE STREAM and USAGE only.
• C. Source table SELECT only.
• D. Database USAGE, Schema CREATE STREAM, USAGE, Source table SELECT.

Answer: (D)

Creating streams on a table requires a set of privileges that cover access, object creation, and data access. You must be able to reach the database and schema, create a stream object in that schema, and read from the source table to feed the stream with the necessary change data.

Having database USAGE lets you navigate to the database where the table lives. Schema CREATE STREAM and USAGE let you define a new stream in that schema and access other objects within it. Source table SELECT grants the permission to read data from the table, which is essential for the stream to capture changes.

If any of these are missing, you can’t set up a new stream: you’d be blocked from accessing the database or schema, unable to create the stream, or unable to read the table’s data. The combination of database USAGE, schema CREATE STREAM and USAGE, and source table SELECT provides the minimal, sufficient set to create additional streams on the table.