Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/security/changes/?format=api&page=7
{ "count": 423, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/security/changes/?format=api&page=8", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/security/changes/?format=api&page=6", "results": [ { "unit": "https://weblate.osgeo.org/api/units/100762/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.674454Z", "action": 4, "target": "新しい接続で接続すると、そのプロパティの中で SSL 接続を使っていることが分かります。", "id": 1896386, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100759/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.663423Z", "action": 4, "target": "次に、PostgreSQL を再起動すると、サーバが SSL 処理の準備ができます。", "id": 1896385, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896385/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100757/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.655388Z", "action": 4, "target": "``postgresql.conf`` ファイル内で、\"ssl\" パラメータを \"on\" にして SSL を有効化します。", "id": 1896384, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896384/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100755/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.648120Z", "action": 4, "target": "``server.crt`` と ``server.key`` を PostgreSQL データディレクトリに複製します。", "id": 1896383, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896383/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100753/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.640788Z", "action": 4, "target": "次に SSL 証明書とキーを取得または生成します。証明書はパスフレーズなしにするのに必要で、無い場合にはデータベースサーバは起動しません。自己署名したキーの生成ができます。次の通り行います:", "id": 1896382, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896382/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100750/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.631140Z", "action": 4, "target": "まず、SSL の有効化に再起動が必要になるので、PostgreSQL を終了させます。", "id": 1896381, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896381/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100748/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-09T07:34:33.609820Z", "action": 4, "target": "SSL接続を使うには、クライアントとサーバの両方が SSL に対応している必要があります。", "id": 1896380, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896380/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100795/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:30:13.531046Z", "action": 7, "target": "`PostgreSQL SSLサポート <https://www.postgresql.jp/document/current/html/libpq-ssl.html>`_", "id": 1896371, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896371/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100794/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:30:11.401482Z", "action": 7, "target": "`PostgreSQL 暗号化 <https://www.postgresql.jp/document/current/html/encryption-options.html>`_", "id": 1896370, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896370/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100793/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:30:07.987089Z", "action": 7, "target": "`PostgreSQL 認証 <https://www.postgresql.jp/document/current/html/auth-methods.html>`_", "id": 1896369, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896369/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100746/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:30:02.088947Z", "action": 7, "target": "SSL 接続", "id": 1896368, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896368/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100744/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:57.996584Z", "action": 7, "target": "データベース内のカラムは pgcryptoモジュール で暗号化できます。このモジュールにはハッシュアルゴリズム、直接暗号化 (blowfish, aes) および公開鍵や対称鍵の PGP 暗号化があります。", "id": 1896367, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896367/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100740/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:48.369201Z", "action": 2, "target": "デフォルトでは、全てのパスワードは MD5 暗号化されます。クライアント/サーバ のハンドシェイクは、MD5 パスワードを二重に暗号化します。パスワードを盗聴する者によるハッシュの再利用を防ぎます。", "id": 1896366, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1896366/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100740/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:44.651496Z", "action": 7, "target": "デフォルトでは、全てのパスワードは MD5 暗号化されます。クライアント/サーバ のハンドシェイクは、MD5 パスワードを二重に暗号化します。パスワードを盗聴する者によりハッシュの再利用を防ぎます。", "id": 1896365, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896365/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100737/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:21.992587Z", "action": 7, "target": "PostgreSQL は多数の `安藤化機能 <https://www.postgresql.jp/document/current/html/encryption-options.html>`_ を提供しています。多数が任意指定であり、一部はデフォルトでオンになっています。", "id": 1896364, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896364/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100733/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:12.669212Z", "action": 2, "target": "では、app1 ユーザとして上のテーブル生成 SQL を試してみて、どうなるかを見て下さい!", "id": 1896363, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1896363/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100733/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:29:06.478663Z", "action": 7, "target": "では、app1 ユーザとして上のテーブル生成 SQL を試してみて、どうなるかを見て下さい。", "id": 1896362, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896362/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100731/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:28:46.506236Z", "action": 7, "target": "開発者や分析者にとっては、PostGIS の主要なメタデータテーブルに対して、もう少し多いアクセスが必要です。PostGIS メタデータテーブルを編集できる ``postgis_writer`` ロールが必要です!", "id": 1896361, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896361/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100729/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:28:39.311994Z", "action": 2, "target": "こららの種類のパーミッションは、読み書きを行う WFS サービスなどで必要です。", "id": 1896360, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1896360/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100729/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:26.619844Z", "action": 7, "target": "こららの種類のパーミッションは、読み書きを行う WFS サービスで必要です。", "id": 1896359, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896359/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100727/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:21.400904Z", "action": 7, "target": "データテーブルへの書込みアクセスが必要なウェブアプリケーションについては、テーブル自体への追加パーミッションの付与が必要なだけで、``postgis_reader`` ロールの使用を継続できます。", "id": 1896358, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1896358/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100795/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.973227Z", "action": 4, "target": "`PostgreSQL SSLサポート <https://www.postgresql.jp/document/current/html/libpq-ssl.html>`_", "id": 1896357, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896357/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100794/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.966148Z", "action": 4, "target": "`PostgreSQL 暗号化 <https://www.postgresql.jp/document/current/html/encryption-options.html>`_", "id": 1896356, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896356/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100793/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.959058Z", "action": 4, "target": "`PostgreSQL 認証 <https://www.postgresql.jp/document/current/html/auth-methods.html>`_", "id": 1896355, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896355/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100746/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.951499Z", "action": 4, "target": "SSL 接続", "id": 1896354, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896354/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100744/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.944456Z", "action": 4, "target": "データベース内のカラムは pgcryptoモジュール で暗号化できます。このモジュールにはハッシュアルゴリズム、直接暗号化 (blowfish, aes) および公開鍵や対称鍵の PGP 暗号化があります。", "id": 1896353, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896353/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100740/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.937661Z", "action": 4, "target": "デフォルトでは、全てのパスワードは MD5 暗号化されます。クライアント/サーバ のハンドシェイクは、MD5 パスワードを二重に暗号化します。パスワードを盗聴する者によりハッシュの再利用を防ぎます。", "id": 1896352, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896352/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100737/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.930552Z", "action": 4, "target": "PostgreSQL は多数の `安藤化機能 <https://www.postgresql.jp/document/current/html/encryption-options.html>`_ を提供しています。多数が任意指定であり、一部はデフォルトでオンになっています。", "id": 1896351, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896351/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100733/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.923047Z", "action": 4, "target": "では、app1 ユーザとして上のテーブル生成 SQL を試してみて、どうなるかを見て下さい。", "id": 1896350, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896350/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100731/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.915699Z", "action": 4, "target": "開発者や分析者にとっては、PostGIS の主要なメタデータテーブルに対して、もう少し多いアクセスが必要です。PostGIS メタデータテーブルを編集できる ``postgis_writer`` ロールが必要です!", "id": 1896349, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896349/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100729/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.907675Z", "action": 4, "target": "こららの種類のパーミッションは、読み書きを行う WFS サービスで必要です。", "id": 1896348, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896348/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100727/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-08T08:27:10.885092Z", "action": 4, "target": "データテーブルへの書込みアクセスが必要なウェブアプリケーションについては、テーブル自体への追加パーミッションの付与が必要なだけで、``postgis_reader`` ロールの使用を継続できます。", "id": 1896347, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1896347/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": null, "author": null, "timestamp": "2023-11-03T09:23:48.256696Z", "action": 17, "target": "", "id": 1896241, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1896241/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100710/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:08:25.824967Z", "action": 2, "target": "app1 としてログインすると、``nyc_streets`` テーブルの行を抽出できます。しかしながら、 :command:`ST_Transform` が実行できません! なぜでしょう?", "id": 1895998, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1895998/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100766/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:08:08.545206Z", "action": 7, "target": "データ暗号化", "id": 1895997, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895997/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100724/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:08:03.579347Z", "action": 7, "target": "作業の一環として新しいテーブルとジオメトリカラムを作成する必要がある開発者と分析者。", "id": 1895996, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895996/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100722/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:59.434372Z", "action": 7, "target": "既存のデータテーブルへの書き込みが必要なウェブアプリケーションなど。", "id": 1895995, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895995/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100720/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:56.566604Z", "action": 7, "target": "考慮する必要のある読み/書きシナリオが二種類あります:", "id": 1895994, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895994/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100718/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:53.367886Z", "action": 7, "target": "読み書き可能ユーザ", "id": 1895993, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895993/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100716/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:49.132998Z", "action": 7, "target": "これで、PostGIS テーブルからデータを読む必要のあるユーザに適用できる汎用的な ``postgis_reader`` ロールができました。", "id": 1895992, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895992/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100714/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:46.091213Z", "action": 7, "target": "このため、``postgis_reader`` ロールに対して全ての PostGIS メタデータテーブルへの読み込み権利を付与する必要があります:", "id": 1895991, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895991/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100712/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:42.238165Z", "action": 7, "target": "答は、エラーメッセージに示されています。``app1`` ユーザが ``nyc_streets`` テーブルの内容を正常に表示できますが、``spatial_ref_sys`` の内容を表示できないため、:command:`ST_Transform` の実行に四敗します。", "id": 1895990, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895990/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100710/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:38.692532Z", "action": 7, "target": "\"app1\" としてログインすると、``nyc_streets`` テーブルの行を抽出できます。しかしながら、 :command:`ST_Transform` が実行できません! なぜでしょう?", "id": 1895989, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895989/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100707/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:35.369594Z", "action": 7, "target": "ウェブアプリケーションは ``nyc_streets`` テーブルへの特定のアクセス権を持ちますが、``postgis_reader`` ロールから PostGIS 操作に必要なシステムアクセス権を継承します。", "id": 1895988, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895988/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100705/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:32.090779Z", "action": 7, "target": "読み取り専用ユーザはウェブアプリケーションが ``nyc_streets`` テーブルに対するクエリを使うためのユーザです。", "id": 1895987, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895987/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100703/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:27.195277Z", "action": 7, "target": "読み取り専用ユーザ", "id": 1895986, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895986/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100701/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:23.880486Z", "action": 7, "target": "機能的には、次に示す二つの SQL ステートメントは同じで、どちらも「ログイン権限を持つロール」つまり「ユーザ」を作ります。", "id": 1895985, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895985/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100698/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:19.717824Z", "action": 7, "target": "ロールはユーザでユーザはロールです。ユーザは \"login\" 権限を持つロールであると言えることとだけが違います。", "id": 1895984, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895984/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100696/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:15.879275Z", "action": 7, "target": "ロールの作成", "id": 1895983, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895983/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100694/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-11-02T09:07:12.944746Z", "action": 7, "target": "ユーザ作成とユーザへの権限付与をせずに、適正な権限を持つ二つのロールを作り、その後に、二つのユーザを作って適切なロールを追加します。この方法で、ユーザよりもロールの方が簡単に再利用ができます。", "id": 1895982, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1895982/?format=api" } ] }