Which privilege is required to use the search optimization service in Snowflake?
Which privilege is required to use the search optimization service in Snowflake?
To add, configure, or remove search optimization for a table in Snowflake, you must have the ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. Therefore, the correct privilege statement is to 'GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>'. This allows the specified role to manage search optimization on tables within the given schema.
C correct https://docs.snowflake.com/en/user-guide/search-optimization-service What Access Control Privileges Are Needed For the Search Optimization Service?¶ To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
https://www.bing.com/search?q=Which+privilege+is+required+to+use+the+search+optimization+service+in+Snowflake%3F&qs=n&form=QBRE&sp=-1&lq=1&pq=which+privilege+is+required+to+use+the+search+optimization+service+in+snowflake%3F&sc=1-80&sk=&cvid=B4C1407FB1A046E49C04B50ACAFBA18C&ghsh=0&ghacc=0&ghpl=