SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ25

Manage and administer Snowflake accounts, data security, and governance

What are the minimum grants needed on the database, schema, and table to correctly create and manage a stream?

Explanation

Creating a stream on a standard table requires the CREATE STREAM privilege on the target schema and SELECT on the source table. The role also needs USAGE on the parent database and schema to access objects in that location.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!