auth_group_permissions

Data license: MIT

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: group_id, permission_id

id ▼ group_id permission_id
1 Editors 2 Can access Wagtail admin 1
2 Moderators 1 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
6 Moderators 1 Can delete document 112
7 Moderators 1 Can add document 110
8 Moderators 1 Can change document 111
9 Editors 2 Can choose document 113
10 Moderators 1 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
14 Moderators 1 Can add image 114
15 Moderators 1 Can change image 115
16 Moderators 1 Can delete image 116
17 Editors 2 Can choose image 117
18 Moderators 1 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");