home / db

auth_group_permissions

Data license: MIT

9 rows where group_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ group_id permission_id
1 Editors 2 Can access Wagtail admin 1
3 Editors 2 Can delete document 112
4 Editors 2 Can add document 110
5 Editors 2 Can change document 111
9 Editors 2 Can choose document 113
11 Editors 2 Can add image 114
12 Editors 2 Can change image 115
13 Editors 2 Can delete image 116
17 Editors 2 Can choose image 117

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE UNIQUE INDEX "auth_group_permissions_group_id_permission_id_0cd325b0_uniq" ON "auth_group_permissions" ("group_id", "permission_id");
CREATE INDEX "auth_group_permissions_group_id_b120cbf9" ON "auth_group_permissions" ("group_id");
CREATE INDEX "auth_group_permissions_permission_id_84c5c92e" ON "auth_group_permissions" ("permission_id");
Powered by Datasette · Queries took 7.607ms · Data license: MIT