Snowflake Gen AI Governance · Topic 6 of 15

Individual Privileges for Cortex Analyst, Search, Agents and Snowflake Intelligence

Know the privileges each Cortex feature needs: search service USAGE, semantic view access, agent USAGE, MODIFY, MONITOR and Snowflake Intelligence grants.

  • 4 min
  • Includes a diagram
In a nutshell
  • Search query: USAGE on service, database and schema. Create: CREATE CORTEX SEARCH SERVICE plus SELECT and a warehouse.
  • Agent privileges: CREATE AGENT, USAGE, MODIFY, MONITOR, OWNERSHIP.
  • Tools need their own grants; the default is to warn, not fail.

What it is

Database roles such as CORTEX_USER open the door to a feature. Individual privileges are the object-level grants that let a role use a particular search service, agent or semantic view. A call succeeds only when the role holds both.

This is the most scenario-heavy part of Cortex security. A typical question describes an agent that fails for one user and asks which grant is missing.

RoleneedsDatabase roleCORTEX_USER or specificandObject privilegeson the featureandData accesstables, warehouse

How it works

Cortex Search

ActionRequirement
Create a serviceCORTEX_USER or CORTEX_EMBED_USER database role, CREATE CORTEX SEARCH SERVICE (or schema ownership), SELECT on the source table or view, USAGE on the refresh warehouse, and change tracking on the source objects
Query a serviceUSAGE on the service, plus USAGE on its database and schema
Suspend or resumeOPERATE on the service
View refresh historyMONITOR, OPERATE or OWNERSHIP on the service
GRANT USAGE ON DATABASE cortex_search_db TO ROLE customer_support;
GRANT USAGE ON SCHEMA cortex_search_db.services TO ROLE customer_support;
GRANT USAGE ON CORTEX SEARCH SERVICE cortex_search_db.services.transcript_search_service TO ROLE customer_support;

Cortex Analyst

Analyst needs the CORTEX_USER or CORTEX_ANALYST_USER database role. For the semantic model or semantic view it also needs:

  • SELECT on the tables the model references (or USAGE on the semantic view and its database and schema),
  • READ or WRITE on the stage when the semantic model YAML file sits on a stage,
  • USAGE on any Cortex Search service the model references.

Running the generated SQL needs a warehouse and is billed separately from the Analyst message.

Cortex Agents

Agent USAGE is not enough: the role also needs privileges on each tool's objects and the warehouse. By default a missing tool privilege only produces warnings and weaker answers.

PrivilegeOnWhat it allows
CREATE AGENTSchemaCreate an agent
USAGEAgentQuery the agent; also needs USAGE on its database and schema
MODIFYAgentUpdate, DROP AGENT and UNDROP AGENT (undrop also needs CREATE AGENT)
MONITORAgentView threads, logs and traces
OWNERSHIPAgentGiven to the creator; transferable
USAGEWarehouseNeeded for the warehouse a tool uses

Agent USAGE alone is not enough. The caller's active roles also need privileges on each tool's objects:

  • Search tool: USAGE on the service, its database and its schema.
  • Analyst tool: USAGE or SELECT on the semantic view, tables and database objects, plus CORTEX_ANALYST_USER or CORTEX_USER.
  • Custom tool (function or stored procedure): USAGE on it.
GRANT USAGE ON AGENT sales_db.agents.support_agent TO ROLE support_role;
GRANT USAGE ON WAREHOUSE agent_wh TO ROLE support_role;

Inaccessible tools

By default (accept), a missing tool privilege does not reject the run. The agent uses the tools it can reach and reports the rest as warnings. Setting orchestration.tool_not_accessible to reject or legacy makes the run fail instead. So a user may get weaker answers without any error, which is a classic trap.

Snowflake Intelligence

Snowflake Intelligence is the agent chat app (recent docs call it Snowflake CoWork). An account has one object, named SNOWFLAKE_INTELLIGENCE_OBJECT_DEFAULT, and you cannot choose another name.

PrivilegeAllows
CREATE SNOWFLAKE INTELLIGENCE ON ACCOUNTCreate the object; held by ACCOUNTADMIN by default
USAGESee the agent list and configuration
MODIFYAdd or remove agents and change configuration; admins have it by default
GRANT USAGE ON SNOWFLAKE INTELLIGENCE SNOWFLAKE_INTELLIGENCE_OBJECT_DEFAULT TO ROLE PUBLIC;
ALTER SNOWFLAKE INTELLIGENCE SNOWFLAKE_INTELLIGENCE_OBJECT_DEFAULT ADD AGENT sales_db.agents.support_agent;

Users still need USAGE on each agent, and sessions start with the user's default role and default warehouse, so set both. To limit a user to the app only, use ALTER USER <name> SET ALLOWED_INTERFACES = (SNOWFLAKE_INTELLIGENCE). Adding an agent to the object makes it visible; it does not grant USAGE on the agent.

Exam tip

Debug a failing agent from the bottom up: role has CORTEX_AGENT_USER, USAGE on agent, USAGE on each tool object, USAGE on the tool warehouse, and a default warehouse set.

AgentUSAGEcallsSearch toolservice USAGEandAnalyst toolsemantic view accessandWarehouseUSAGE

Common mistakes

Granting agent USAGE only. The tools' objects need grants too.

Missing database and schema USAGE. Object USAGE is useless without them.

Missing change tracking on a source table when creating a search service.

Assuming adding an agent to Snowflake Intelligence grants access. It only lists it; USAGE on the agent is separate.

Expecting an error for an inaccessible tool. The default behavior is a warning.

What to remember for the exam

  • Search query: USAGE on service, database and schema. Create: CREATE CORTEX SEARCH SERVICE plus SELECT and a warehouse.
  • Agent privileges: CREATE AGENT, USAGE, MODIFY, MONITOR, OWNERSHIP.
  • Tools need their own grants; the default is to warn, not fail.
  • Snowflake Intelligence object has CREATE, USAGE and MODIFY privileges.

Check yourself

  • Which privilege lets a role view an agent's traces?

    MONITOR on the agent.

  • A user can query an agent but answers ignore the Search tool. Why?

    The role lacks USAGE on the search service or its schema, and the default accept behavior skips the tool with a warning.

  • What does MODIFY on the Snowflake Intelligence object allow?

    Adding or removing agents and changing configuration.

Topic 6 of 15 in Snowflake Gen AI Governance

Test yourself on Snowflake Gen AI Governance

The full Snowflake GES-C02 question bank has 585 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.