← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/security.cfg

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-05-23 18:43:31 UTC
  • mfrom: (13084.2.6 page-match-rewrite-url)
  • Revision ID: launchpad@pqm.canonical.com-20110523184331-dhd2c7cgfuu49epw
[r=sinzui][bug=784273] Adds facility to the PageMatch to handle bad
        URIs

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/security.cfg
10
10
public_schemas=ts2
11
11
 
12
12
[public]
13
 
type=group
14
13
public._killall_backends(text)             =
15
14
public.activity()                          = EXECUTE
16
15
public.add_test_openid_identifier(integer) = EXECUTE
79
78
public.valid_name(text)                    = EXECUTE
80
79
public.valid_regexp(text)                  = EXECUTE
81
80
public.version_sort_key(text)              = EXECUTE
82
 
# BugSummary trigger functions and helpers.
83
 
public.bug_row(integer)                    =
84
 
public.bug_summary_dec(bugsummary)         =
85
 
public.bug_summary_flush_temp_journal()    =
86
 
public.bug_summary_inc(bugsummary)         =
87
 
public.bug_summary_temp_journal_ins(bugsummary) =
88
 
public.bugsummary_journal_inc(bugsummary)  =
89
 
public.bugsummary_locations(bug)           =
90
 
public.bugsummary_tags(bug)                =
91
 
public.bugsummary_tasks(bug)               =
92
 
public.bugsummary_viewers(bug)             =
93
 
public.ensure_bugsummary_temp_journal()    =
94
 
public.summarise_bug(bug)                  =
95
 
public.unsummarise_bug(bug)                =
 
81
type=group
96
82
 
97
83
[ro]
98
84
groups=read
140
126
public.bugnotificationfilter            = SELECT, INSERT, UPDATE, DELETE
141
127
public.bugnotificationrecipient         = SELECT, INSERT, UPDATE, DELETE
142
128
public.bugnotificationrecipientarchive  = SELECT, UPDATE
143
 
public.bugsummary                       = SELECT
144
 
public.bugsummaryjournal                = SELECT
145
 
public.bugsummary_rollup_journal()      = EXECUTE
146
129
public.bugtag                           = SELECT, INSERT, DELETE
147
130
public.bugtrackercomponent              = SELECT, INSERT, UPDATE
148
131
public.bugtrackercomponentgroup         = SELECT, INSERT, UPDATE
157
140
public.codeimportresult                 = SELECT, INSERT, UPDATE, DELETE
158
141
public.codereviewmessage                = SELECT, INSERT, DELETE
159
142
public.codereviewvote                   = SELECT, INSERT, UPDATE, DELETE
160
 
public.combinedbugsummary               = SELECT
161
143
public.commercialsubscription           = SELECT, INSERT, UPDATE, DELETE
162
144
public.continent                        = SELECT
163
145
public.customlanguagecode               = SELECT, INSERT, UPDATE, DELETE
236
218
public.openidrpconfig                   = SELECT, INSERT, UPDATE, DELETE
237
219
public.packagebugsupervisor             = SELECT, INSERT, UPDATE, DELETE
238
220
public.packagebuild                     = DELETE
239
 
public.packagecopyjob                   = SELECT, INSERT, UPDATE
240
221
public.packagecopyrequest               = SELECT, INSERT, UPDATE
241
222
public.packagediff                      = SELECT, INSERT, UPDATE, DELETE
242
223
public.packageset                       = SELECT, INSERT, UPDATE, DELETE
274
255
public.revision                         = SELECT, INSERT, UPDATE
275
256
public.revisionauthor                   = SELECT, INSERT, UPDATE
276
257
public.revisioncache                    = SELECT, INSERT, UPDATE, DELETE
 
258
public.revisionnumber                   = SELECT, INSERT
277
259
public.revisionparent                   = SELECT, INSERT
278
260
public.scriptactivity                   = SELECT
279
261
public.seriessourcepackagebranch        = SELECT, INSERT, UPDATE, DELETE
563
545
public.bugcve                           = SELECT, INSERT
564
546
public.bugjob                           = SELECT, INSERT
565
547
public.bugmessage                       = SELECT, INSERT, UPDATE
566
 
public.bugmute                          = SELECT
567
548
public.bugnomination                    = SELECT
568
549
public.bugnotification                  = SELECT, INSERT
569
550
public.bugnotificationfilter            = SELECT, INSERT
818
799
public.distribution                           = SELECT
819
800
public.distributionjob                        = SELECT, INSERT
820
801
public.distributionsourcepackage              = SELECT, INSERT
821
 
public.distroseriesparent                     = SELECT
822
 
public.packagecopyjob                         = SELECT, INSERT
823
802
public.packagediff                            = SELECT, INSERT, UPDATE
824
803
public.sourcepackagepublishinghistory         = SELECT, INSERT, UPDATE, DELETE
825
804
type=user
855
834
public.cve                              = SELECT, INSERT
856
835
public.distributionjob                  = SELECT, INSERT, DELETE
857
836
public.distributionsourcepackage        = SELECT, INSERT, UPDATE
858
 
public.distroseriesparent               = SELECT, INSERT, UPDATE
859
837
public.flatpackagesetinclusion          = SELECT, INSERT, UPDATE, DELETE
860
838
public.gpgkey                           = SELECT, INSERT, UPDATE
861
839
public.job                              = SELECT, INSERT, UPDATE
866
844
public.messagechunk                     = SELECT, INSERT
867
845
public.milestone                        = SELECT
868
846
public.packagebugsupervisor             = SELECT
869
 
public.packagecopyjob                   = SELECT, INSERT, DELETE
870
847
public.packagecopyrequest               = SELECT, INSERT, UPDATE
871
848
public.packagediff                      = SELECT, INSERT, UPDATE
872
849
public.packageset                       = SELECT, INSERT
879
856
public.project                          = SELECT
880
857
public.publisherconfig                  = SELECT, INSERT
881
858
public.question                         = SELECT
 
859
public.questionjob                      = SELECT, INSERT
882
860
public.questionbug                      = SELECT
883
 
public.questionjob                      = SELECT, INSERT
884
861
public.questionsubscription             = SELECT
885
862
public.sourcepackagepublishinghistory   = SELECT, INSERT, UPDATE, DELETE
886
863
public.structuralsubscription           = SELECT
909
886
public.distribution                           = SELECT, UPDATE
910
887
public.distroarchseries                       = SELECT, UPDATE
911
888
public.distroseries                           = SELECT, UPDATE
912
 
public.distroseriesparent                     = SELECT
913
889
public.emailaddress                           = SELECT
914
890
public.flatpackagesetinclusion                = SELECT
915
891
public.gpgkey                                 = SELECT
975
951
public.distributionjob                          = SELECT
976
952
public.distroarchseries                         = SELECT, INSERT
977
953
public.distroseries                             = SELECT, UPDATE
978
 
public.distroseriesparent                       = SELECT, INSERT, UPDATE
979
954
public.flatpackagesetinclusion                  = SELECT, INSERT
980
955
public.gpgkey                                   = SELECT
981
956
public.job                                      = SELECT, INSERT, UPDATE
982
957
public.libraryfilealias                         = SELECT
983
958
public.libraryfilecontent                       = SELECT
984
959
public.packagebuild                             = SELECT, INSERT
985
 
public.packagecopyjob                           = SELECT
986
960
public.packageset                               = SELECT, INSERT
987
961
public.packagesetgroup                          = SELECT, INSERT
988
962
public.packagesetinclusion                      = SELECT, INSERT
1003
977
 
1004
978
[sync_packages]
1005
979
groups=script
1006
 
public.account                                = SELECT
1007
980
public.archive                                = SELECT
1008
981
public.archivepermission                      = SELECT, INSERT
1009
982
public.binarypackagebuild                     = SELECT, INSERT
1017
990
public.component                              = SELECT
1018
991
public.componentselection                     = SELECT, INSERT
1019
992
public.distribution                           = SELECT
1020
 
public.distributionjob                        = SELECT, INSERT, UPDATE
1021
 
public.distributionsourcepackage              = SELECT, INSERT, UPDATE
 
993
public.distributionjob                        = SELECT
1022
994
public.distroarchseries                       = SELECT, INSERT
1023
995
public.distroseries                           = SELECT, UPDATE
1024
 
public.distroseriesdifference                 = SELECT
1025
 
public.distroseriesdifferencemessage          = SELECT, INSERT, UPDATE
1026
 
public.distroseriesparent                     = SELECT
1027
 
public.emailaddress                           = SELECT
1028
996
public.flatpackagesetinclusion                = SELECT, INSERT
1029
997
public.gpgkey                                 = SELECT
1030
998
public.job                                    = SELECT, INSERT, UPDATE, DELETE
1031
999
public.libraryfilealias                       = SELECT, INSERT, UPDATE, DELETE
1032
1000
public.libraryfilecontent                     = SELECT, INSERT
1033
 
public.message                                = SELECT, INSERT, UPDATE
1034
 
public.messagechunk                           = SELECT, INSERT, UPDATE
1035
1001
public.packagebuild                           = SELECT, INSERT
1036
 
public.packagecopyjob                         = SELECT, UPDATE
1037
1002
public.packageset                             = SELECT, INSERT
1038
1003
public.packagesetgroup                        = SELECT, INSERT
1039
1004
public.packagesetinclusion                    = SELECT, INSERT
1040
1005
public.packagesetsources                      = SELECT, INSERT
1041
 
public.packageupload                          = SELECT, INSERT
1042
 
public.packageuploadsource                    = SELECT
 
1006
public.packageupload                          = SELECT
1043
1007
public.packaging                              = SELECT, INSERT
1044
1008
public.person                                 = SELECT
1045
1009
public.pocketchroot                           = SELECT
1061
1025
public.distributionjob                          = SELECT
1062
1026
public.distroseries                             = SELECT
1063
1027
public.distroseriesdifference                   = SELECT, INSERT, UPDATE
1064
 
public.distroseriesparent                       = SELECT
1065
1028
public.job                                      = SELECT, UPDATE
1066
1029
public.libraryfilealias                         = SELECT
1067
1030
public.libraryfilecontent                       = SELECT
1068
 
public.packagecopyjob                           = SELECT
1069
1031
public.packagediff                              = SELECT
1070
1032
public.packageset                               = SELECT
1071
1033
public.sourcepackagename                        = SELECT
1093
1055
public.bugattachment                    = SELECT, INSERT, UPDATE
1094
1056
public.bugjob                           = SELECT, INSERT
1095
1057
public.bugmessage                       = SELECT, INSERT, UPDATE
1096
 
public.bugmute                          = SELECT, INSERT, UPDATE, DELETE
1097
1058
public.bugnomination                    = SELECT, INSERT, UPDATE
1098
1059
public.bugpackageinfestation            = SELECT, INSERT, UPDATE
1099
1060
public.bugproductinfestation            = SELECT, INSERT, UPDATE
1267
1228
public.bugcve                           = SELECT, INSERT
1268
1229
public.bugjob                           = SELECT, INSERT
1269
1230
public.bugmessage                       = SELECT, INSERT
1270
 
public.bugmute                          = SELECT
1271
1231
public.bugnomination                    = SELECT
1272
1232
public.bugnotification                  = SELECT, INSERT
1273
1233
public.bugnotificationfilter            = SELECT, INSERT
1295
1255
public.distroarchseries                 = SELECT
1296
1256
public.distrocomponentuploader          = SELECT
1297
1257
public.distroseries                     = SELECT, UPDATE
1298
 
public.distroseriesparent               = SELECT
1299
1258
public.emailaddress                     = SELECT, INSERT, UPDATE
1300
1259
public.flatpackagesetinclusion          = SELECT
1301
1260
public.gpgkey                           = SELECT, INSERT
1310
1269
public.milestone                        = SELECT
1311
1270
public.packagebugsupervisor             = SELECT
1312
1271
public.packagebuild                     = SELECT, INSERT, UPDATE
1313
 
public.packagecopyjob                   = SELECT, INSERT
1314
1272
public.packagediff                      = SELECT, INSERT, UPDATE, DELETE
1315
1273
public.packageset                       = SELECT
1316
1274
public.packagesetgroup                  = SELECT
1372
1330
public.bugcve                           = SELECT, INSERT
1373
1331
public.bugjob                           = SELECT, INSERT
1374
1332
public.bugmessage                       = SELECT, INSERT
1375
 
public.bugmute                          = SELECT
1376
1333
public.bugnomination                    = SELECT
1377
1334
public.bugnotification                  = SELECT, INSERT
1378
1335
public.bugnotificationfilter            = SELECT, INSERT
1399
1356
public.distroarchseries                 = SELECT
1400
1357
public.distrocomponentuploader          = SELECT
1401
1358
public.distroseries                     = SELECT
1402
 
public.distroseriesdifference           = SELECT
1403
 
public.distroseriesparent               = SELECT
1404
1359
public.emailaddress                     = SELECT, INSERT, UPDATE
1405
1360
public.flatpackagesetinclusion          = SELECT
1406
1361
public.gpgkey                           = SELECT
1415
1370
public.milestone                        = SELECT
1416
1371
public.packagebugsupervisor             = SELECT
1417
1372
public.packagebuild                     = SELECT, INSERT, UPDATE
1418
 
public.packagecopyjob                   = SELECT, INSERT
1419
1373
public.packagediff                      = SELECT, UPDATE
1420
1374
public.packageset                       = SELECT
1421
1375
public.packagesetgroup                  = SELECT
1482
1436
public.bugattachment                    = SELECT
1483
1437
public.bugjob                           = SELECT, INSERT
1484
1438
public.bugmessage                       = SELECT, INSERT
1485
 
public.bugmute                          = SELECT
1486
1439
public.bugnomination                    = SELECT
1487
1440
public.bugnotification                  = SELECT, INSERT, UPDATE
1488
1441
public.bugnotificationfilter            = SELECT, INSERT
1672
1625
public.bugcve                           = SELECT, INSERT
1673
1626
public.bugjob                           = SELECT, INSERT
1674
1627
public.bugmessage                       = SELECT, INSERT
1675
 
public.bugmute                          = SELECT
1676
1628
public.bugnomination                    = SELECT, INSERT, UPDATE
1677
1629
public.bugnotification                  = SELECT, INSERT
1678
1630
public.bugnotificationattachment        = SELECT
2021
1973
public.bugproductinfestation            = SELECT, UPDATE
2022
1974
public.bugsubscription                  = SELECT, UPDATE
2023
1975
public.bugsubscriptionfilter            = SELECT, UPDATE, DELETE
2024
 
public.bugsummary                       = SELECT
2025
1976
public.bugtask                          = SELECT, UPDATE
2026
1977
public.bugtracker                       = SELECT, UPDATE
2027
1978
public.bugtrackerperson                 = SELECT, UPDATE
2148
2099
public.bugsubscriptionfilterimportance  = SELECT
2149
2100
public.bugsubscriptionfilterstatus      = SELECT
2150
2101
public.bugsubscriptionfiltertag         = SELECT
2151
 
public.bugsummary_rollup_journal()      = EXECUTE
2152
2102
public.bugtag                           = SELECT
2153
2103
public.bugwatch                         = SELECT, UPDATE
2154
2104
public.bugwatchactivity                 = SELECT, DELETE