SNOWFLAKE DOCS DIFF
本日は全8436ページ中、6ページが改訂され、削除はありませんでした。重要度は仕様変更2件、実質更新3件、些末な更新1件で、破壊的変更はありません。主な動きは、Organization Hub Insights のアクセス制御とアプリケーションロールの説明拡充です。SQL コマンド領域では、CREATE ORGANIZATION USER の参照性と記述体裁が改善されました。
Insights のアクセス制御説明が拡充され、GLOBALORGADMIN または ORGANIZATION_USAGE のアプリケーションロールによってアクセスが決まること、別個の Insights 権限は存在しないことが明記されました。さらに、ページアクセスとタイル単位のアクセスを分離し、ORGANIZATION_ACCOUNTS_VIEWER、ORGANIZATION_BILLING_VIEWER、ORGANIZATION_GOVERNANCE_VIEWER、ORGANIZATION_SECURITY_VIEWER、ORGANIZATION_USAGE_VIEWER の用途が表で追加説明されています。
影響: GLOBALORGADMIN を付与せずに必要なアプリケーションロールだけを付与でき、権限不足のタイルを含む部分表示も想定したアクセス設計が必要になります。
判定根拠: SQL 構文/コードブロックの増減 (+15/-0)
--- ahttps://docs.snowflake.com/en/user-guide/organization-hub-insights+++ bhttps://docs.snowflake.com/en/user-guide/organization-hub-insights@@ -16,7 +16,9 @@ 1. Use %sf-web-interface-link% to sign in to the organization account.-2. Switch to the GLOBALORGADMIN role, or to a role that has been granted the appropriate- [ORGANIZATION_USAGE application roles](/sql-reference/organization-usage#label-org-usage-access-org-account).+2. Switch to the `GLOBALORGADMIN` role, or to a role that has been granted the appropriate `ORGANIZATION_USAGE` application roles.+ For more information, see [](#label-org-hub-access-control). 3. In the navigation menu, select **Organization Hub** %raa% **Insights**.++<a id="label-org-hub-highlights"></a> ## High-level highlights@@ -244,9 +246,174 @@ ## Access control requirements -Users with the GLOBALORGADMIN role can access Insights. Designated users and roles that have been granted the appropriate-[ORGANIZATION_USAGE application roles](/sql-reference/organization-usage#label-org-usage-access-org-account) can also access-Insights. Those application roles include ORGANIZATION_BILLING_VIEWER for cost data, ORGANIZATION_SECURITY_VIEWER for security-data, and ORGANIZATION_GOVERNANCE_VIEWER and ORGANIZATION_USAGE_VIEWER for query and warehouse data. For the full list, see+Every Insights tile reads from a view in the `ORGANIZATION_USAGE` schema, so access to Insights is determined entirely by which+[ORGANIZATION_USAGE application roles](/sql-reference/organization-usage#label-org-usage-access-org-account) a user's role holds.+There is no separate Insights privilege.++Users with the `GLOBALORGADMIN` role can read every `ORGANIZATION_USAGE` view, so they see all tiles. To give someone access without+granting `GLOBALORGADMIN`, grant one or more of the granular application roles described in this section.++<a id="label-org-hub-access-evaluation"></a>++### How access is evaluated++Snowflake evaluates access at two levels:++- **Page access.** Insights appears in the navigation menu, and the page opens, for a user whose role holds `GLOBALORGADMIN` or at+ least one of the granular application roles in the following table.+- **Tile access.** Each tile is authorized separately when it queries its underlying view. Tiles that the current role can read+ render normally. Tiles that it can't read display a message stating that your role doesn't hold the required application role,+ and the rest of the page continues to work.++Because the two levels are independent, a role with a single granular application role can open Insights and see a partially+populated page. This is expected: grant additional application roles to fill in the remaining tiles.++<a id="label-org-hub-app-roles"></a>++### Application roles used by Insights++Insights uses the following application roles:++<div className="colwidths-given">++ <colgroup>+ <col style={{ width: "40.0%" }} />+ <col style={{ width: "60.0%" }} />+ </colgroup>+ <thead>+ <tr>+ <th>Application role</th>+ <th>Data it makes visible in Insights</th>+ </tr>+ </thead>+ <tbody>+ <tr>+ <td>`ORGANIZATION_ACCOUNTS_VIEWER`</td>+ <td>+ The list of accounts in the organization. Required for the account+ filter and for tiles that break results down by account.+ </td>+ </tr>+ <tr>+ <td>`ORGANIZATION_BILLING_VIEWER`</td>+ <td>Cost in currency and contract utilization.</td>+ </tr>+ <tr>+ <td>`ORGANIZATION_GOVERNANCE_VIEWER`</td>+ <td>+ Query-level data, which comes from the+ [QUERY_HISTORY](/sql-reference/organization-usage/query_history) view.+ </td>+ </tr>+ <tr>+ <td>`ORGANIZATION_SECURITY_VIEWER`</td>+ <td>+ Users, logins, administrator role membership, and Trust Center findings.+ </td>+ </tr>+ <tr>+ <td>`ORGANIZATION_USAGE_VIEWER`</td>+ <td>Credit consumption, storage, and warehouse load.</td>+ </tr>+ </tbody>++</div>++`ORGANIZATION_OBJECT_VIEWER` grants access to object inventory views such as+[DATABASES](/sql-reference/organization-usage/databases), which no Insights tile reads. Granting it alone does not make Insights+usable.++<a id="label-org-hub-section-roles"></a>++### Application roles required by each section++Some sections of Insights combine data from more than one domain and therefore require more than one application role:++<div className="colwidths-given">++ <colgroup>+ <col style={{ width: "30.0%" }} />+ <col style={{ width: "70.0%" }} />+ </colgroup>+ <thead>+ <tr>+ <th>Section</th>+ <th>Application roles</th>+ </tr>+ </thead>+ <tbody>+ <tr>+ <td>**Billing and Cost**</td>+ <td>+ `ORGANIZATION_BILLING_VIEWER` for the cost and contract utilization tiles,+ and `ORGANIZATION_USAGE_VIEWER` for the storage tile.+ </td>+ </tr>+ <tr>+ <td>**Security**</td>+ <td>`ORGANIZATION_SECURITY_VIEWER`.</td>+ </tr>+ <tr>+ <td>**Query health**</td>+ <td>+ `ORGANIZATION_GOVERNANCE_VIEWER` for the query tiles, and+ `ORGANIZATION_USAGE_VIEWER` for the warehouse load tile.+ </td>+ </tr>+ </tbody>++</div>++The [high-level highlights](#label-org-hub-highlights) at the top of the page summarize the sections that follow, so each highlight+follows the same rules as the tile it summarizes.++To confirm which application role a specific view requires, see [Access schema in the organization account](/sql-reference/organization-usage#label-org-usage-access-org-account).++<a id="label-org-hub-grant-example"></a>++### Example: Grant granular access to Insights++The following example creates a role for a security analyst who needs the **Security** section of Insights, but no cost or query+data. Run these statements in the organization account:++```sql+USE ROLE GLOBALORGADMIN;++CREATE ROLE org_security_analyst;++-- Security tiles: users, logins, admin role membership, and Trust Center findings.+GRANT APPLICATION ROLE SNOWFLAKE.ORGANIZATION_SECURITY_VIEWER TO ROLE org_security_analyst;++-- Account list, so the analyst can filter and group results by account.+GRANT APPLICATION ROLE SNOWFLAKE.ORGANIZATION_ACCOUNTS_VIEWER TO ROLE org_security_analyst;++-- Organization Hub runs queries on a warehouse.+GRANT USAGE ON WAREHOUSE org_hub_wh TO ROLE org_security_analyst;++GRANT ROLE org_security_analyst TO USER jsmith;+```++When `jsmith` switches to `org_security_analyst` and opens **Organization Hub** %raa% **Insights**, the **Security** section is+populated, and the **Billing and Cost** and **Query health** tiles report that the role doesn't hold the required application role.++To extend the same role to the rest of Insights, grant the remaining application roles:++```sql+USE ROLE GLOBALORGADMIN;++GRANT APPLICATION ROLE SNOWFLAKE.ORGANIZATION_BILLING_VIEWER TO ROLE org_security_analyst;+GRANT APPLICATION ROLE SNOWFLAKE.ORGANIZATION_GOVERNANCE_VIEWER TO ROLE org_security_analyst;+GRANT APPLICATION ROLE SNOWFLAKE.ORGANIZATION_USAGE_VIEWER TO ROLE org_security_analyst;+```++Alternatively, grant `SNOWFLAKE.ORG_USAGE_ADMIN`, which grants access to every view in the `ORGANIZATION_USAGE` schema, including views+that Insights doesn't use.++To review what a role can already read, use+[SHOW GRANTS](/sql-reference/sql/show-grants):++```sql+SHOW GRANTS TO ROLE org_security_analyst;+``` Command Center is documented separately and requires GLOBALORGADMIN. See
TYPE および PERSON の説明にページ内アンカーが追加され、本文中の TYPE 表記がコード形式に統一されました。SERVICE ユーザーのリンク例では、埋め込み SQL コードブロックが削除され、詳細は SYSTEM$LINK_ORGANIZATION_USER の別ページを参照する形式に変更されています。
影響: SQL 構文や機能の変更はなく、主に参照性とドキュメントの体裁が変わった改訂です。
判定根拠: SQL 構文/コードブロックの増減 (+1/-4)
--- ahttps://docs.snowflake.com/en/sql-reference/sql/create-organization-user+++ bhttps://docs.snowflake.com/en/sql-reference/sql/create-organization-user@@ -96,4 +96,5 @@ </dd>+<a id="label-org-user-type-property"></a> <dt>`TYPE = { PERSON | SERVICE }`</dt> <dd>@@ -102,4 +103,5 @@ <dl>+<a id="label-org-user-type-property-person"></a> <dt>`PERSON`</dt> <dd>@@ -127,5 +129,5 @@ You can't change the type after you create the organization user. The [](/sql-reference/sql/alter-organization-user) command doesn't-accept the TYPE property.+accept the `TYPE` property. Default: `PERSON`@@ -160,5 +162,5 @@ ## Examples -Create an organization user and set the EMAIL property. Because the TYPE property isn't specified, the organization user is a+Create an organization user and set the EMAIL property. Because the `TYPE` property isn't specified, the organization user is a `PERSON` user: @@ -176,9 +178,4 @@ When an account administrator imports an organization user group that contains `etl_pipeline`, the user object created in the regular-account is also a `SERVICE` user. If a service user named `etl_pipeline` already exists in the account, the administrator can link it to-the organization user by calling-[](/sql-reference/functions/system_link_organization_user), because both users are `SERVICE` users:--```sql-SELECT SYSTEM$LINK_ORGANIZATION_USER('etl_pipeline', 'etl_pipeline');-```+account is also a `SERVICE` user. For an example of linking this kind of organization user to an existing service user, see+[](/sql-reference/functions/system_link_organization_user).
Organization user types の見出しレベルを変更し、「human」を「person」に言い換えました。また、ユーザー種別を指定する TYPE プロパティと、競合解決時にリンク対象となる既存ユーザーの適格性を明確化し、TYPE の表記もコード形式に統一しました。機能・構文・既定値の変更はありません。
影響: 主に説明の明確化と体裁の統一であり、ユーザー管理の実務上の動作変更はありません。
変更内容: 本文を更新(7行追加・7行削除)
--- ahttps://docs.snowflake.com/en/user-guide/organization-users+++ bhttps://docs.snowflake.com/en/user-guide/organization-users@@ -72,8 +72,8 @@ <a id="label-org-users-types"></a> -### Organization user types--An organization user is either a `PERSON` user, which represents a human, or a `SERVICE` user, which represents a service or application-that interacts with Snowflake without human interaction. Specify the TYPE property to choose between them. If you don't specify a type, the+## Organization user types++An organization user is either a `PERSON` user, which represents a person, or a `SERVICE` user, which represents a service or application+that interacts with Snowflake without human interaction. Specify the `TYPE` property to choose between them. If you don't specify a type, the organization user is a `PERSON` user. For the characteristics of each type, including the authentication methods that a service user can use, see [](/user-guide/admin-user-management#label-user-management-types).@@ -93,6 +93,6 @@ - The type of the user objects that Snowflake creates when an account administrator imports an organization user group. Importing a group that contains `etl_pipeline` creates a `SERVICE` user named `etl_pipeline` in the regular account.-- Which existing users the organization user can be linked to when an account administrator resolves a conflict. For more information, see- [](#label-org-users-conflicts).+- The existing users that the organization user is eligible to link to, when an account administrator resolves a conflict. For more+ information, see [](#label-org-users-conflicts). `PERSON` and `SERVICE` are the only types available to an organization user. Other user types, such as `SERVICE_AGENT` and@@ -271,5 +271,5 @@ The two users must have compatible types. A `SERVICE` organization user can only be linked to a `SERVICE` local user. A `PERSON`- organization user can only be linked to a local user that is a `PERSON` user or whose TYPE property is `NULL`. If the types aren't+ organization user can only be linked to a local user that is a `PERSON` user or whose `TYPE` property is `NULL`. If the types aren't compatible, the function returns an error and the local user isn't linked. Because you can't change the type of an organization user, use [](/sql-reference/sql/alter-user) to change the type of the local user, then link it. For example, to link a service user that predates
TYPE表記がコード形式に統一され、説明文の改行が調整されました。加えて、リンク後は通常アカウントでTYPEを変更できない旨に、organization user typesの詳細ドキュメントへの参照リンクが追加されました。
影響: 機能や構文の変更はなく、TYPEの互換性と変更不可の仕様を確認する参照先が明確になりました。
変更内容: 本文を更新(4行追加・3行削除)
--- ahttps://docs.snowflake.com/en/sql-reference/functions/system_link_organization_user+++ bhttps://docs.snowflake.com/en/sql-reference/functions/system_link_organization_user@@ -44,6 +44,6 @@ organization user. -The TYPE property of the local user must be compatible with the TYPE property of the organization user. Snowflake treats a user whose TYPE-property is `NULL` as a `PERSON` user, so the types are compatible in the following cases:+The `TYPE` property of the local user must be compatible with the `TYPE` property of the organization user. Snowflake treats a user whose+`TYPE` property is `NULL` as a `PERSON` user, so the types are compatible in the following cases: <div className="colwidths-auto">@@ -59,5 +59,6 @@ local user to a `PERSON` organization user. Because the type of an organization user can't be changed, resolve this kind of conflict by creating the organization user with the type you need, or by using [](/sql-reference/sql/alter-user) to change the type of the local user-before you link it. After a local user is linked, its TYPE property can no longer be changed in the regular account.+before you link it. After a local user is linked, its `TYPE` property can no longer be changed in the regular account. For more+information about organization user types, see [](/user-guide/organization-users#label-org-users-types). ## Examples
SHOW ORGANIZATION USERS の結果に、組織ユーザーの種類を示す type 列が追加されました。可能な値の一覧への参照も追加されています。
影響: 結果セットを列位置や列数で処理している既存ツールでは、type 列の追加による影響を確認する必要があります。
変更内容: 本文を更新(4行追加・0行削除)
--- ahttps://docs.snowflake.com/en/sql-reference/sql/show-organization-users+++ bhttps://docs.snowflake.com/en/sql-reference/sql/show-organization-users@@ -123,4 +123,8 @@ <td>User-specified description of the organization user object.</td> </tr>+ <tr>+ <td>`type`</td>+ <td>Type of the organization user. For a list of possible values, see [](/user-guide/organization-users#label-org-users-types).</td>+ </tr> </tbody>
(この変更は要約対象外です。diff を参照してください)
判定根拠: 書式・空白のみの変更
--- ahttps://docs.snowflake.com/en/sql-reference/sql/alter-organization-user+++ bhttps://docs.snowflake.com/en/sql-reference/sql/alter-organization-user@@ -59,5 +59,5 @@ Set object properties. For a description of the object properties, see [](/sql-reference/sql/create-organization-user). -The TYPE property isn't included in the object properties that this command accepts. You choose whether an organization user is a+The `TYPE` property isn't included in the object properties that this command accepts. You choose whether an organization user is a `PERSON` or a `SERVICE` user when you create it, and you can't change the type afterward.
| セクション | S | A | B | C | 計 |
|---|---|---|---|---|---|
| SQL Commands | 0 | 1 | 1 | 1 | 3 |
| User Guide | 0 | 1 | 1 | 0 | 2 |
| SQL Functions | 0 | 0 | 1 | 0 | 1 |