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=3
{ "count": 423, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/security/changes/?format=api&page=4", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/security/changes/?format=api&page=2", "results": [ { "unit": "https://weblate.osgeo.org/api/units/2340042/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.377578Z", "action": 9, "target": "**Certificate**-autentisering är ett alternativ om du förväntar dig att alla klientanslutningar ska ske via SSL och om du kan hantera distributionen av nycklar.", "id": 2134397, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134397/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340041/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.347184Z", "action": 9, "target": "LDAP_ är en annan vanlig autentiseringsmetod för företag. Servern `OpenLDAP <http://www.openldap.org/>`_ som levereras med de flesta Linux-distributioner tillhandahåller en implementering av LDAP_ med öppen källkod.", "id": 2134396, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340040/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.321213Z", "action": 9, "target": "Kerberos_ är en standard autentiseringsmetod för företag som används av både GSSAPI_ och SSPI_-scheman i PostgreSQL. Med hjälp av SSPI_ kan PostgreSQL autentisera mot Windows-servrar.", "id": 2134395, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134395/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340039/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.295578Z", "action": 9, "target": "**Password** är ett grundläggande system där lösenorden lagras i databasen med MD5-kryptering.", "id": 2134394, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134394/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340038/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.270854Z", "action": 9, "target": "PostgreSQL stöder många olika `autentiseringsmetoder <http://www.postgresql.org/docs/current/static/auth-methods.html>`_, för att möjliggöra enkel integration i befintliga företagsarkitekturer. För produktionsändamål används följande metoder vanligtvis:", "id": 2134393, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134393/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340037/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.247304Z", "action": 9, "target": "Autentisering", "id": 2134392, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134392/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340036/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.220515Z", "action": 9, "target": "Och se till att den är vändbar också!", "id": 2134391, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134391/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340035/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.192186Z", "action": 9, "target": "Testa sedan krypteringsfunktionen.", "id": 2134390, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134390/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340034/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.164949Z", "action": 9, "target": "Först aktiverar du pgcrypto genom att ladda Contrib SQL-filen, antingen i PgAdmin eller psql.", "id": 2134389, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134389/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340033/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.138555Z", "action": 9, "target": "Modulen pgcrypto_ har ett stort utbud av krypteringsalternativ, så vi kommer bara att demonstrera det enklaste användningsfallet: kryptering av en datakolumn med hjälp av ett symmetriskt chiffer.", "id": 2134388, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134388/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340032/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.116126Z", "action": 9, "target": "Kryptering av data", "id": 2134387, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134387/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340031/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.092553Z", "action": 9, "target": "Observera hur terminalen rapporterar SSL-statusen för anslutningen.", "id": 2134386, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340030/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.072632Z", "action": 9, "target": "Eftersom standardläget för SSL-anslutning är \"prefer\" behöver du inte ens ange en SSL-preferens när du ansluter. En anslutning med kommandoraden ``psql`` terminal kommer att plocka upp SSL-alternativet och använda det som standard:", "id": 2134385, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134385/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340029/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.050767Z", "action": 9, "target": "När du ansluter till den nya anslutningen kan du se i dess egenskaper att den använder en SSL-anslutning.", "id": 2134384, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134384/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340028/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.030022Z", "action": 9, "target": "När servern är aktiverad för SSL är det enkelt att skapa en krypterad anslutning. I PgAdmin skapar du en ny serveranslutning (Arkiv > Lägg till server...) och ställer in SSL-parametern på \"require\".", "id": 2134383, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134383/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340027/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:02.006086Z", "action": 9, "target": "Starta nu PostgreSQL igen; servern är redo för SSL-drift.", "id": 2134382, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134382/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340026/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.985749Z", "action": 9, "target": "Aktivera SSL-stöd i filen ``postgresql.conf`` genom att ändra parametern \"ssl\" till \"on\".", "id": 2134381, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134381/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340025/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.962901Z", "action": 9, "target": "Kopiera `` server.crt`` och `` server.key`` till PostgreSQL-datakatalogen.", "id": 2134380, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134380/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340024/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.941126Z", "action": 9, "target": "Därefter skaffar eller genererar vi ett SSL-certifikat och en nyckel. Certifikatet får inte innehålla någon lösenfras, annars kommer databasservern inte att kunna startas. Du kan generera en självsignerad nyckel enligt följande:", "id": 2134379, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134379/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340023/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.917989Z", "action": 9, "target": "Stäng först av PostgreSQL, eftersom aktivering av SSL kommer att kräva en omstart.", "id": 2134378, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134378/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340022/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.895229Z", "action": 9, "target": "För att kunna använda SSL-anslutningar måste både klienten och servern ha stöd för SSL.", "id": 2134377, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134377/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340021/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.872608Z", "action": 9, "target": "SSL-anslutningar", "id": 2134376, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134376/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340020/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.850334Z", "action": 9, "target": "Kolumner i databasen kan krypteras med hjälp av modulen pgcrypto_, som innehåller hash-algoritmer, direkta chiffer (blowfish, aes) och både PGP-kryptering med offentlig nyckel och symmetrisk kryptering.", "id": 2134375, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134375/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340019/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.826169Z", "action": 9, "target": "`SSL-anslutningar <http://www.postgresql.org/docs/current/static/libpq-ssl.html>`_ är valfritt tillgängliga mellan klienten och servern för att kryptera all data och inloggningsinformation. Autentisering med SSL-certifikat är också tillgänglig när SSL-anslutningar används.", "id": 2134374, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134374/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340018/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.802084Z", "action": 9, "target": "Som standard är alla lösenord MD5-krypterade. Handskakningen mellan klient och server dubbelkrypterar MD5-lösenordet för att förhindra att hashen återanvänds av någon som snappar upp lösenordet.", "id": 2134373, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134373/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340017/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.774933Z", "action": 9, "target": "PostgreSQL tillhandahåller många `krypteringsfaciliteter <http://www.postgresql.org/docs/current/static/encryption-options.html>`_, många av dem valfria, några av dem är på som standard.", "id": 2134372, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134372/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340016/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.752282Z", "action": 9, "target": "Kryptering", "id": 2134371, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134371/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340015/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.728920Z", "action": 9, "target": "Prova nu att skapa tabellen SQL ovan som app1-användare och se hur det går!", "id": 2134370, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134370/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340014/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.706249Z", "action": 9, "target": "För utvecklare och analytiker behövs lite mer tillgång till de viktigaste PostGIS-metadatatabellerna. Vi kommer att behöva en ``postgis_writer`` roll som kan redigera PostGIS metadatatabeller!", "id": 2134369, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134369/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340013/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.683217Z", "action": 9, "target": "Den här typen av behörigheter krävs t.ex. för en WFS-tjänst för läsning/skrivning.", "id": 2134368, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134368/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340012/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.659804Z", "action": 9, "target": "För webbapplikationer som kräver skrivåtkomst till datatabeller behöver vi bara ge extra behörigheter till själva tabellerna, och vi kan fortsätta att använda rollen ``postgis_reader``.", "id": 2134367, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134367/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340011/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.636367Z", "action": 9, "target": "Utvecklare eller analytiker som behöver skapa nya tabeller och geometrikolumner som en del av sitt arbete.", "id": 2134366, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134366/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340010/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.612472Z", "action": 9, "target": "Webbapplikationer och andra som behöver skriva till befintliga datatabeller.", "id": 2134365, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134365/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340009/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.589271Z", "action": 9, "target": "Det finns två typer av läs/skriv-scenarier som vi måste ta hänsyn till:", "id": 2134364, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134364/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340008/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.566947Z", "action": 9, "target": "Läsa/skriva Användare", "id": 2134363, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134363/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340007/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.543774Z", "action": 9, "target": "Nu har vi en generisk roll, ``postgis_reader``, som vi kan använda för alla användare som behöver läsa från PostGIS-tabeller.", "id": 2134362, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134362/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340006/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.520463Z", "action": 9, "target": "Därför måste vi också ge rollen ``postgis_reader`` läsåtkomst till alla PostGIS-metadatatabeller:", "id": 2134361, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134361/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340005/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.497349Z", "action": 9, "target": "Svaret finns i felmeddelandet. Även om vår ``app1`` användare kan se innehållet i ``nyc_streets`` tabellen bra, kan den inte se innehållet i ``spatial_ref_sys``, så anropet till :command:`ST_Transform` misslyckas.", "id": 2134360, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134360/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340004/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.473564Z", "action": 9, "target": "Nu, när vi loggar in som app1, kan vi välja rader från tabellen ``nyc_streets``. Vi kan dock inte köra ett :command:`ST_Transform`-anrop! Varför kan vi inte det?", "id": 2134359, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134359/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340003/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.450573Z", "action": 9, "target": "Programmet kommer att ha specifik åtkomst till tabellen ``nyc_streets``, men kommer att ärva den nödvändiga systemåtkomsten för PostGIS-operationer från rollen ``postgis_reader``.", "id": 2134358, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134358/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340002/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.427114Z", "action": 9, "target": "Vår skrivskyddade användare kommer att användas av en webbapplikation för att söka i tabellen ``nyc_streets``.", "id": 2134357, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134357/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340001/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.404272Z", "action": 9, "target": "Skrivskyddade användare", "id": 2134356, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134356/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340000/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.381321Z", "action": 9, "target": "Så funktionellt sett är de två SQL-satserna nedan desamma, de skapar båda en \"roll med inloggningsbehörighet\", det vill säga en \"användare\".", "id": 2134355, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134355/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339999/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.358170Z", "action": 9, "target": "En roll är en användare och en användare är en roll. Den enda skillnaden är att en \"user\" kan sägas vara en roll med \"login\"-rättigheter.", "id": 2134354, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134354/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339998/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.334978Z", "action": 9, "target": "Skapa roller", "id": 2134353, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134353/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339997/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.312076Z", "action": 9, "target": "I stället för att skapa användare och ge dem de nödvändiga befogenheterna skapar vi två roller med rätt befogenheter och skapar sedan två användare och lägger till dem i lämpliga roller. På så sätt kan vi enkelt återanvända rollerna när vi skapar ytterligare användare.", "id": 2134352, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134352/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339996/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.288033Z", "action": 9, "target": "En läs/skriv-användare som används av en utvecklare för att bygga en programvara eller analysera data.", "id": 2134351, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134351/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339995/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.264717Z", "action": 9, "target": "En skrivskyddad användare för användning i en publiceringsapplikation.", "id": 2134350, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134350/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339994/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.242951Z", "action": 9, "target": "I det här kapitlet kommer vi att skapa två användbara produktionsanvändare:", "id": 2134349, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134349/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2339993/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T13:14:01.220261Z", "action": 9, "target": "Användare och roller", "id": 2134348, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134348/?format=api" } ] }