Oracle’s shared Select AI teams separate workflow ownership from execution—but not from privileges
Cross-schema reuse narrows who can edit an agent team, while every consumer still needs the database and tool permissions required at runtime.
Oracle’s September release for Select AI Agent Framework teams solved a practical enterprise problem: one database schema can own an agent team, while users or roles in other schemas are granted permission to run it by an owner-qualified name. That makes a centrally maintained workflow reusable without copying its agents, tasks and tools into every consumer schema. But the privilege boundary is easy to misunderstand: permission to run the team is not permission to everything the team may touch.
The team is the unit of delegation
Oracle’s detailed sharing guide says the owner keeps control of the team definition—including workflow composition, task order, prompts and tool configuration. A consumer who receives access can run the shared team but cannot independently run or modify its underlying agents, tasks or tools, and cannot receive separate grants on those components through the team-access mechanism. Runtime values supplied through SET_TEAM or RUN_TEAM customize one execution without changing the stored definition.
That is a useful split for platform teams. The owner can update one governed workflow while consumers invoke the same version. It also reduces the chance that an application role quietly edits a prompt or swaps a tool while retaining the appearance of using the approved team.
Execution still uses the caller’s authority
The less obvious rule appears in Oracle’s prerequisites: DBMS_CLOUD_AI_AGENT uses the privileges of the user calling the package, and shared-team operations run with that caller’s privileges. A consumer therefore needs EXECUTE on the package and on any owner-defined PL/SQL tool functions that the team calls. External URLs require a credential object.
Oracle is explicit that GRANT_TEAM_ACCESS grants only permission to run the named team. It does not grant access to credentials, database objects, PL/SQL functions or other resources used by the workflow. Teams activated with SET_TEAM also require the owner to receive TRANSLATE SQL on the consumer user; without that grant, activation fails with insufficient privileges.
The deployment test
Treat a shared team as a versioned orchestration object, not as a security wrapper. Before rollout, test it under the actual consumer role—not the owner account—and inventory every database object, PL/SQL function, credential and translation grant needed by each path. Then revoke one dependency at a time and confirm that the failure is contained and auditable.
The operating model is therefore two-layered: team access decides who may invoke the workflow; ordinary database privileges decide what that invocation can actually do. Keeping those layers separate is the feature. Assuming the first layer implicitly supplies the second is the deployment bug.
sources
comments · 0