I have encountered some privileges in Snowflake for which I can't find documentation where I would expect to find them (https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html):
What do these privileges do, and where are they documented? I have only been able to find scant references on the web.
ADD SEARCH OPTIMIZATION
What Access Control Privileges Are Needed For the Search Optimization Service?
To add 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.
CREATE TAG
Summary of DDL Commands, Operations, and Privileges
Create tag.
A role with the USAGE privilege on the parent database and schema with the CREATE TAG privilege in the same schema.
REBUILD
REFERENCE USAGE
Use the REFERENCE_USAGE privilege when sharing a secure view that references objects belonging to multiple databases, as follows:
The REFERENCE_USAGE privilege must be granted individually to each database.
The REFERENCE_USAGE privilege must be granted to a database before granting SELECT on a secure view to a share.
